Using a parent form to select names from a cbo box
and two subforms to edit tables.
Parent child link is SSN
The Tables may have multiple records for an employee

I have the following SQL statement that I copied from a query to try to
put it into code.
I get a "Type Mismatch" error on the last line of the statement before
the DoCmdRunSQL runs.  I <think> it's from the NewORNum, but can't be

I have a main form and a subform. The main form has all the data for
the parent record. The subform has all the data for the child
record(s). There can be many child records for a single parent record.
I want to always be able to add new parent records. Under given

Have a Parent form with cbobox to select names
and two subforms linked by ssn.
each sform uses a table as data source.
i want to be able to select name on parent form and then

I have a split 2003 Access program.  The code is Wc.mdb and the data is
WCData.mdb.  I want to have a button to press to get it to back up the linked
data (WCData - NOT the program portion) only. I don't want them to have to go
to the backend to do it either.  I'd like to be able ...

I have several databases using access XP, but one of them I cannot step
through the code in debug mode - have I inadvertantly switched this off?
Thanks

Is it possible to have a database work as a mediator on importing dbase
files into access, prompted for table name (better yet, current date as
table name) and save as a different database?  Or is there a VB application
for this?  I will be importing dbase files about 3 times a week ...

I have an application where I can open a couple of forms.
Sometimes I get the message that there's not enough memory
to update the screen.
How does the forms affect the memory use, and is there a

How am I set global variable on the main form which can be referred by
another from when the main form is still active.

I have 12 fields on my form.  The first field's properties are set to
"indexed (no duplicates)" at the table level and also set with a primary
key.  Next I created a form using the wizard so these values transferred
over to my form.  Here's my problem.

Is it possible using conditional formating to set the
ForeColor property of a combobox depending on the value of
another combobox on the same form?
thanks in advance, george

What would be the best approach to use for a form to track music volumes,
i.e.... a main form with a combo box to select a volume, a continuous form
to list all tracks for the volume and another subform to list all the
artists for the currently active track. My main form for ...

I have a main form with a tab control on it. The first tab has a record navigation control at the bottom. When I use the control to move to the next record I see the form fields change accordingly. On the second tab I have a subform which displays records in datasheet view based ...

I have a main form based on one table.  When ControlA on
this form is updated, I need to show the last value of the
subform's ControlB(subform based on a seperate table with
1:m relationship) that is related to the value in the main

I have a three subforms.  The following visual basic code works in hiding
the various parts of one of the subforms.  This code is an event that takes
place "after click".
Me.TabCtl33.Visible = False    'Hides all three subforms.