I have a main form.
There are two subforms on this main form.  When a control has focus on
subform 1, after it is updated I want to reference the control on the second
subform.  This is Access 2003.  What is the syntax to do this?  I have tried

I have a tab control with 8 pages. Each page has its own subform who's
record source is the same (tblTest). Before I click the send button, I am
trying to determine if the form was completed correctly. There are other
subforms within the parent form, buf for some reason, I cannot ...

  Is there a way and How can I access are two different questions. Please
go through question and you will find the difference. let me make my question
clear by another example. Say, I make two table tblEmpInfo and tblSalaryInfo.
Both table are in relationship with a field EMPID ...

Hi!
Thanks in advance for your help. I have an issue and have not been able to
find a similar one on the forums.
I have a form which collects user requirements for a report through a

I have two fields on my form, consequence and probability.  They are filled
from drop down menus that contain the phrases very low, low, medium, high and
very high.  Each of those are assigned a value of 1 through 5 respectively.  
A third field, exposure, is calculated as the ...

    I want to know to code to access data of two different tables in a
single form? Let me make my question clear by an exaple--- suppose I make two
tables tblName and tblAge. In tblName I have two fields say name and address,
and in tblAge I have two another fields age and ...

I have a DSum that is giving me problems.  It says wrong synatx.  Any
suggestions welcome.
Thanks
DS

I have a datasheet.  When user clicks on a cell I have a modal window open
and then change a value which updates the table which the datasheet shows.
1. when I open the modal window the code continues after the docmd.openform
in the datasheet and it does not wait for it to return

I created a DB a while ago to record people who did not attend training.  As
there are new courses, staff groups, bases, training rooms etc that can be
added at any time, I added a requery sub command so that as soon as they are
added to the respective table they can be seen in ...

I'm sure I'm missing something simple here, but I'm just not seeing it
right now.
A2003. I have a form which uses a query as it's recordset. I have a command
button on the form that resorts the records when clicked. The code all works

I have a table that contains detailed descriptions.  The table has two
fields, an identifier field (id) and then one longer memo field (descrip).  
I have a form that’s based on a separate table and in this form I would like
to have a lookup field or combo box that can look up the ...

Thank you for the help - No OLE stuff here sir.
One thing that I noticed - Where I have relationships I have two
indexes on one of the tables.
For example: Table1 and a "lookup" table - employer. The child record

I have a program that calculates values for each field in a table. After the
calculation, the results will be added into the table. Now I would like to
write code to clean up the current table which holds the data from last
calculation. Below is the code, but it does not clean up ...

I have been scanning the previous posts and I am not sure where my error is
that is causing the Error 35602: Key is not unique in collection.
I have the following code in which an error is called at the line:
    Set nodCurrent = objTree.Nodes.Add(, , "a" & rst!SACCatID, strText)

I have a listbox, when I select a record it sets an unbound textboxes value.
Me.TxtOne = Me.Listbox.Column(1)
The underlying value is long Integer
I have a second textbox (Me.TxtTwo) on the page it's default value is set to