One of my users is having trouble with the Treeview control on my main form.  
They can select and expand the nodes, but when they click on them to load a
form into the sub form, nothing happens!!!
They are using Runtime to access the database and all other users are

I need the user to enter data in each field - in order.  Can I prevent the
user tabbing onto another field if a mandatiory field is left Null ?

I'm so far behind on delevering this database I can't think straight..
I have to allow the user to choose from 3 list boxes and return the report
based on those choices.
This code has two of the choices on it..

Access 2003
Trying to assemble a bunch of fields, place it in a text control, highlight
it and simulate Ctrl-C using SendKeys.
It does not work; probably because the field with the highlighted text must

Ive got this action query qrySetTransferred. It changes the flag of one
of the yes/no fields from no to yes. I've got no idea how to invoke
this query from VB code? I do not need to collect any recordset, just
run the appending query and continue with my code.. What's the function

I have a main form with a treeview control, and several subforms on a tab
control. Depending on the treeview node determines the recordsource for the
appropriate subform, and whether it is editable or not. I am controlling the
recordsource to restrict the recordset to a single ...

I have a form that pop's up if the user click a button. I need to pass the
data from on feild on my main form to a feild on the pop up form. I tried
using the me.fldname = me.fldname after the DoCmd, but that didn't do it.
Any Ideas?

Question:  How do I make the Combo Box display the default value after I
click on the Combo Box?
I posted this question earlier, but found that I had made my question too
confusing.

I have a form call "Audits", which contains the following field:
"Audit Table"
Policy Number
Insured

Hi,
How can I know the record count of the result from sql:
    db.Execute str1, dbFailOnError
I want to execute an INSERT query in a loop, as long as there is result.

I have a standand form which shows one record at a time.  The record is
consist of a Policy Number and Billing Type.  What I want to do is somehow
in my form shows if the user looks for a particular policy number that the
form perhaps in a lable or text box or a subform shows the ...

I have read all the arguments here that calculated values should not be
stored in a table, but have to bounce it off of ya'll one more time.  I am
developing an access form that will grade test scores, compare pre- and
post-tests for change in knowledge and then calculate the ...

Can some one give me direction. I think this is a simple thing to do
but can not get anything to work.
I have a form with a sub form, the sub form is a Tabular form from a
table. The form only shows a few of the fields.

I get a run-time error when I run this code. When I do the debug it appears
that its finding the data. Its failing on the DoCmd.
I don't know why this isn't working. I have used this same type of code
before to open a form and find the specific item.

I need to confirm the existance of specific data in my If statement.
However the data is located in on subform and the code is run from another
subform.
I need to check to see if the word ROOM is in the fld called ITEM. If it is