On my Main Menu I have a dropdown list from a Combo Box (cbFinishHorse),
that shows me Horses that are in Finished Status. I am trying to write the
code for AfterUpdate. So as when I click the name of the horse his form
Record appears.

I am fairly new to access (4 weeks) and am building a customer database. I
have one main form with several tabs and subforms on it. Currently when the
database is opened they enter their name, press a button which takes them to
a switchboard from which they search for customers ...

I have the date of birth on one form and the referral date on another.  On
the form with the referral date, I want to calculate age at time of referral.
Here's the expression I've tried in various places (in a SetValue macro,
unbound control).  

Albert Kallal's WordMerge is working very nicely now but I have a problem
with one mergefield:
I have an Employees table and a field on the form with a dropdown and that
enables the relevant name to be displayed.

Good day,
What I want to do is a little bit more complicated than the title.
I have a form that has an embedded sub form. I use a drop down in the
form to affect the values in the sub form. This works fine, however my

Is there a way I can prevent free text entry in a combo box without
having to change it to a list box?  I don't know VB and have searched
the help files and the Access Bible with no luck, so I'm thinking this
is not possible.

I am trying to set the default value of an unbound text box using a macro.  
In the AfterUpdate property in the combo box I've added this macro using
SetValue:
Item:  [Forms]![frmReferrals_Main]![RefNote]

I'm not sure in which group I should post this, and I had a hard time coming
up with a descriptive subject line.  I have asked about this topic before,
and thought I had come up with a solution, but it seems not.
Here is the situation.  I have a Contacts table and a related ...

I have used a sample listbox search form from another database that will
allow you to type and it automatically start listing records that correspond
to that particular letter or letters.
My problem is this...Once I click my record search button the search form

what sequence of numbers will give me the back ground color of Access 2003
Application Background.
I have a form with no borders and i want it to belnd in with the background.
I already found "Set a color property to a system color" in the help file,

I have created a form with multiple tabs.  A few of the items from my first
tab are also showing on any additional tabs.  Most of the items are correctly
only showing on the first tab.  I cannot find the control to "assign" the
text box etc. to tab 1.

I have three forms....One main form with information and a choice of
Yes/No.  When Yes is selected a form pops up for data entry.  When No
is selected a different form pops up for data entry.  The problem is
that there is no link to the parent form so the data entered is not

Greetings, thanks for assisting a newbie trying to stay afloat.
I'm designing a form that would notify the data enterer when a duplicate
value is entered into a particualr field. This field identifies a specific
production run of our product and we want to be notified witha  ...

Okay, this is what I want to create.  I thought it would be easy, perhaps I'm
just having a mind blank, but I can't figure it out.
I have a main form with course information.
I want a subform with student info - name, location and contact info.

I have a parking database that I need to send emails out to people once
they have been assigned a parking spot. I have 3 different types of
parking (handicap, VIP and Regular).
The problem is I have 2 check boxes one for VIP and 1 for handicap and