I wasn’t sure if this belonged in Forms or Reports. Since my question
involves both  I decided to  put it in the forms section. Please let me know
if I need to repost it in another section.
Is it possible to Concatenate (or its equivalent) and NOT display in an open

On a tab page a have a subform with a list box in it. When
I view the tab page the first record of the listbox is
highlighted in black and this doesn't look good.
Is it possible to either avoid having the record

I a trying to call the following function on the After Update event of a
control.  The function code is:
Function ShadeCtls(txt As TextBox)
Dim ctlName As TextBox

I created a databes which basically is an expansion or the template Order
Entry from scratch. All of the relationships are ok, the forms are working, I
enter data from combo boxes and the following related fields automatically
display the appropriate info. However when I review ...

Hi. I can't figure out why a couple portions of my (not
so great) code won't kick off (see snippet below).  I put
breaks in my code (thanks to an earlier post reply!).  I
think maybe I need a lesson in "0" vs. "null" as well.  

I want to add records through a form to two related tables (related one to
many on fldDateID) -- the primary table = tblDates (fldID, fldDate,
fldDescrip, fldFormat) -- the related table tblSchedule (fldDateID, fldTime,
fldPlayer ...).

We have a database that opens an 'initial' form on database open and stays
open while our data entry enter data into subsequent forms in a series by
hitting a 'Next' Command Button.  We have the following code behind that
button that goes to the initial form ('fScrEligCriteria' ...

I have a continuous subform.  Each record has a dropdown with a value
selected.  I would like to put a field in the form footer that counts the
number of records being displayed with a specific value in the dropdown.
What formula can I use?

I am trying to send 2 parameters from a form in a VB module as a filter to a
form. But only one of the fields if populating. I don't know how much
information is needed on your side but here's  the code - it's a click event.
[The Year is an unbound field on the form. It's in a ...

I have a main form named "Cases" and subform named "Time_Spent" .  This
subform has a rectangle box/object I placed on it named "Box1" using the
toolbox.  I would like to click on a button I placed on the main form and
make this object invisible but I do not know the proper ...

Hi. I posted earlier about a loop I can't seem to get
through.  There is chance to debug (no error type, just
an Access msg box).  
How can I step through my code to see where I am, so I

I have two combo boxes on a form.  Their intent is to allow a user to select
a record on the form by choosing a value in either combo box.
I have written code to automatically update one combo box when the other is
changed.  Here is the code:

I'm having a problem with a control in access 2000.
I have two textboxes on a form called start and length
In the controlSource of a third textbox I have =[start]+Year[length]
The problem is when I enter data into the field I get nutty results.

I have a continuous subform that is for entering estimates.  In order to
streamline the process, I want to populate a description field when the user
tabs out of an ID field.  I don't want the user to be able to leave the ID
field blank, so I check for this in the Exit event code ...

I have an action query that I'd like to change on the fly in VBA
strGroupNo is a working parameter
It seems like I have everything in place, but it doesn't run:
'=========================================