I have an unbound form with 2 subforms on it (customer info and site info).
Each subforms is linked to a combo box on the main form. When I select a
value from the 1st combo box (customer), it requeries the second combo box
and displays customer info on the first subform. When I ...

This is very strange and seems to be happening out of the blue.
I have a form (Form A) that has a button that opens another form (Form B).
When you click this button, Form B is supposed to populate a list box based
on a text box on Form A.  A simple query was created in row source ...

When I type in data in my form, the numbers are rounding off like 42.36 will
round off to 42... How do I change this

I have a form (TIME SHEET ENTRY) that I can enter employee name, where he
worked, the hours he worked and the week.
The employee name is a combo box. The name is looked up but the employee
number (which is text) is stored in the table.

Sorry I previously posted this in the wrong topic Wont't do it again.
I have a tabbed form which works fine other than the fact that when I change
tab, the record field [ComplaintNumber] located on the subform of main form
does not update on the other tabs, meaning on the main ...

I have a main form “CapitalItems” which has a subform “Vehiclesbf”.  I want
to show “Vehiclessbf” if the field “Acct#” on the mainform is equal to 392.  
For all other values I do not want the subform to show.  
I am using a macro:

I have a date field on a form that must only be a sunday date.  I want to
attach a macro that will show a message box if the date entered is not a
Sunday.  I have tried several ways to achieve this but not been sucessful.
Any help would be gratefully appreciated.

Is there any way to delete a string out of many string under the same column?
For example:-
In a serial number column consists of MY111, MY 123, MY456
If user specify to delete MY456, it will delete MY456 while retaining the

I wanto concatenate text in the field like MY123, MY234 under same field.
Below are my code:-
mySQL6 = "UPDATE WIPRawDetails SET  SerialNumber =  SerialNumber   & '" & Me.
txtI_SerialNumber & "' WHERE PartNumber= '" & Me.txtPartNumber & "' AND

How can I automatically check if there has data changed in a table?
Can I have a popup about that?
Hannu

This is the first time i've ever posted on this board, so bear with
me. I am trying to add data validation to one column, that checks the
value of another column in the same form, and if the value is true,
not allow a 0 to be entered in the column.

Is there a way to put a text box on the form which is driven by a
subform for that form? In this instance, the subform displays a child
record which represents an actual child. The users would like to see
the child name at the top of the form, directly under the mother's

I need help in creating a command button that will open a different
form in the SAME window.  I know how to create a button that will open
a form in a DIFFERENT window, but not in the same window.  Is that
possible?

I want to have a control or series of controls that are only visible when a
certain control option is selected e.g. when a check box is false a series of
controls are invisible but becomes visible when the box is checked true. How
do I do this?

Our department uses an Access database to track each employee's time.  We
currently have two major tables.  The first is a listing of all projects,
each of which is identified by both a Project Number and a Project Name.  The
2nd table is a listing of all detailed time.  This is ...