I have two forms that open up in succession and stay visible together as part
of my invoice creation process.
When we have finished editing the second form, I want to have a single Close
button that will close both forms with one click.

I have a table linked to the header of my form. The table has for records.
Here's what happens. When I choose a record (say record 3) record 1 ALWAYS
prints.
The form is meant to be printed out.

I'm using the following in the On Click of a command button.
DoCmd.GoToRecord acDataForm, "frmMyForm", acNewRec
Anyway I can do this without referenceing the Object (Form) name??
James

I am using Access 2007.  I have several tables created for Purchase Order and
a Purchase Order subform.  The purchase order has the purchase order subform
embedded in it.  I have several combo boxes in the form.  The combo boxes are
for supplies and shipping methods.  When I open ...

Can Access recognize a duplicate value in an indexed (Yes, no duplicates)
field as soon as you type it in and exit that field?  Currently, Access lets
you enter all data on a form and then when you try to move to the next form
you get the error message stating you have a ...

How to define the recodsettype property when loading the form.
Sometimes I want that the forms loads as Dynaset and sometimes as Snapshot.
Regards,
Marco

I have 2 tables in a many to many relationship, using a junction table to
match records.
I need to build a form to allow data entry into both forms, plus create the
junction record to match the two.

I am using Access 2007.  Lately my macros and VB event procedures triggeed by
buttons have stopped working and given me error messages (e.g. looking for a
parameter when one is present and coded correctly).  If I open the VB editor
the problem goes away, and I haven't done ...

We have several access databases that we used without any problems for years.
All databases are in access2003 format and have forms with VB code behind it.
recently we are getting new PC's that cannot execute the forms in (MDE
version) databases. It reports missing references. ...

I have 2 fields, Nature_of_advice1 and Nature_of_advice2.  Either of these
fields can select the option "other" which will then show fields Other1 or
Other2 for completion.  This part works fine!  However, if the user selects
"other infection state" in either of the first 2 ...

I have just hit a very strange problem with a form in an Access 2003
application. The 14 point text in some of my labels significantly degrades
in quality as soon as you spin the mousewheel to scroll through several
records. The text seems to partially bleed into the background ...

Hi.  I have a combobox OnChange event which should update a form's datasource
base on the combobox's value in Colum1.  Code is below.  But when this code
executes I get the error "Run-time error '2001': You canceled the previous
operation."

I've created a form with a combox box and a button to search for records in a
table. The button is linked to a macro which filters the table, opens and
shows the desired record(s) in another form.
The 'where' condition in the macro specifies the criteria for filtering, ie.

I have a form that after making a choice (ie. Customer), it will open up
another form with functions you can do on that customer.  But after opening
up that secondary form I want to make sure the "Choose Customer" form closes.
What is the best way to do this?

I have a form in which we enter the time in (set as Medium Time) and time out
(set as Medium Time) and then another box I have a formula (=[Time Out]-[Time
In]) which shows the time spent.  Is there a way to have an error window pop
up if the time out is before the time in? Or ...