I have a form that shows a date field.  When the date field is empty (null),
how can I change the fill color on form to another color.  Build expression
for null value?

I have 2 combo boxes on a form.  When the user inputs something that is not
in the list, error 2237 is generated (what you have entered is not in the
list... please select an item in the list.)  In the form's On error event, I
have changed this message to a custom message in user ...

How is it possible to open a 'small' form (not in modal) restored and let
the main form maximized?
I've tried to use the a PopUp form, but I can't set up the value
myForm.PopUp = True or False when I need it by code due to a runtime error

I have an employment summary form for keeping a record of employee
employment history.  I have a main form based on the Employees table and a
subform based on a query, which is in turn based on a Details table that
stores Employer, StartDate, and EndDate.  The Details query ...

Hello you all,
NorthwindCS has a customer phone list which I'm interested in but I noticed
that it allows data editing and it shouldn't be happening. I changed Permit
Editing option under the DATA tab to No and blocked the editing part as

I have a main form "A" with a subform "B." When a button, "lock/unlock" on
form A is pressed, one existing button on subform B is set to invisisble and
two other command buttons are set to visible.  
Here is the problem:

background info:
I have Drivers table (PK DriverID)
Vehicles table (PK VRM)
VehiclesDrivers table (PK VRM and DriverID)

I have a form with fields txtStudentRef txtAno and txtSemester.
There is also a subform to show the Details the student studies in my
school. On the subform are the same textboxes with the same information
and the student's details.

I am trying to complete an age range combo box automatically based on the
date of birth entered by the user but also allow the age range combo box to
be used if no date of birth is provided.
I have tried to use the DateDiff function but can't get it to work so then

I have a form with 2 subcontrols (each a form). User inputs required info in
main form combo box, in combo box 1 and then combo box 2. This works great.
Subcontrol2 form contains unbound data fields only, populated on the On
Change event in combo box 2.

I have an existing company that is growning and my limited database skills
are preventing us from using Access further.
Here's my problem:  I cannot figure out how to create a form that pulls data
from multiple tables.  I would put all the fields in one table, but Access

    What I am trying to do is run an append query to add a row in a table
but I only want to append the row of the form I am in. For example, I
want to append Names into a different table but only when a button is
pressed on the form, and I only want that one value appended. How ...

I need to differentiate between items in a list box. I thought color is a
good technique. Anybody doing it?

All,
Not sure why this happens and hopefully someone can enlighten me. I have a
form that has a query assign to it:
(SELECT DepositLog.*, Customer.Addr1, Customer.Addr2, Customer.City,

All,
I have a subform. The subform's data source is a query that is based upon
two fields in the parent form. When the parent form is run, even the blank
new record line is not displayed. I entered a set of data manually. This