I created a subform within my main form and everything is
okay.  Records are saved and showing.
The problem is I cannot go to the subform not
until I filled all required fields on the main form.

my database has two tables -Boats and logsheets with a one to many
referential join on the BoatID field
the logsheet form has a combo box for entering the boat id using a select
query from the boats table to populate the list which works fine. If the

Need to have users close access only from the form
open at that time (form has docmd.quit on close event)
Is it possible to mask the standard Access Window
so only the forms show?

I have two fields in a table :"Line of Business" and "Parent Line of
Business". I want to organize the data in a tree structure and display it in
Access 2000. I would also like to select the relevant "Line of Business" from
this tree.

As I understand it, MS Access uses a mechanism when the user loses focus
from main to subform.  After that point you cannot use the Undo method to
clear the form.
I would like to make a procedure to handle both cases:

I try to run an access 97 program but it gives an error:
"Microsoft Access has encountered a problem and needs to close. We are sorry
for the inconvenience."
I click for more information as following:

How do I do to copy several files of a folder for other, using VBA?

I have a command button that once clicked on runs a query which eventually
creates a desired error. How do I tell the database to open a specific form
(let call it Form1) once the error happens. THANKYOU FOR YOUR HELP!!

I have created a form that uses a autonumber to keep records of my tasks.  
Using the form, I wish to populate that autonumber into another table or
form.  How do I do that?

Hello to all.
Having the above problem, I tried various ways for the correct syntax but
ended always up being asked to type in the value for my query manually:
Right now the following criteria is set in the query called on button click:

I have an auto exec function that starts a series of macros.  I also have a
need to run a different set of macros on Monday only.  How can I have a
small form with two buttons pop up first, so the user can choose which set
of macros to run?

Access 97 has a limit on the number of controls that can be used in a form.  
Can this limit be changed?
Gregg

I've created a form with several fields. Two of those fields use DLOOKUP to
auto-fill that field.  The DLOOKUP function works perfectly in the form.  
However, the data from the DLOOKUP fields do not update the table.  All other
fields in the form update the table properly.

I'm created a QBF (query by form) that will search multiple fields for same
criteria.  For example:  I want search the Company Address, Primary Contact,
and CC fields for a the same name, say "Margaret"
Company | Contact | CC

I am looking to put a manual counter on a form that a user can click an up
button to add one to the number or click a down button to subtract one form
the current number. Can anyone help me with this?
Thanks!