I have a main form with a sub-form.  I want to place a Check box on my main
form.  When the check box is clicked, I want another form to open and
auto-populate with the selected information off the Main form and sub-form.  
I know how to place the check box and do the macro to ...

I have a form called "orders by customer" by customer, on this form I
have a sub form called "orders by customer subform".
At the moment I have it that you double click an order in the "orders
by customer subform" and it opens up another form called "orders" to

I have done most of that already (not opening external program though).
There are no reports so I can't continue.
"Larry Linson" <bouncer@localhost.not> wrote in message
news:uo%23VP6IsIHA.5068@TK2MSFTNGP02.phx.gbl...

How can I check thru code, the status on a control, if the control is
visible or not? (i change it many times thru code)
Thanks

I recently reinstalled windows and office and now the cascading combo boxes
on my form will not populate. Any idea will be greatly appreciated.
Thanks
TC

We had information that was being entered into a spreadsheet that we imported
into Access through the Import command and let it create the table
automatically.  This table is used to capture weekly work detail information
for employees (Payroll Table).

Hello, all!  I have a problem that from the outset seems easy,
and there's plenty of information on here and other forums on the
subject, but nothing that answers my question.
I have a form with a control called PageID whose control source is a

I have a form that when I click on the close button would like for it to
check the data in the Subform and make sure that the Date fields are not null,
if it is I would like a message box to pop up and say "Please fill in the
date", I am not sure if its possible to do it with a ...

I have a unique index set on two fields in my table, InspDate and StoreNo.  I
am trying to trap the error of attempting to add a duplicate by having the
code below in the LostFocus Event for the InspDate.  I am running around in
circles.  Can someone please help?

I have the following code on a form.  The form is modal and popup.  This
allows me to maximize the form on load.  My problem is that when I click that
button, it is behind the main form.  How can I make it be in front without
losing the modal and popup?

In Access 97 i have same linked tables (to dbase).
How know what is the linked path?... how to change the path?...
Thanks,
Nuno Gomes

My goal is to use a form to prompt a query and open up a report.  
What I would like on the form is to have a combo box to select one of three
tables.  Then, have a second combo box appear with the fields from the
selected table to choose from.

I want to develop a form that has a command button which will open a
parameter query. The parameter is a date field. There are 3 dates:
"ScreeningDate", "ICFDate", and "D1Tx", each of which is drawn from a table.
I need to be able to open the query if any of those 3 fields are ...

Hopefully someone can assist.I need to run an Apphend Query using the Event
'After Update' - I have already assigned the query and it works, however I
need to be specific, in terns of the records it appends. The scenario is that
I have a tabbed form - main form and subforms. The ...

I am trying to display the last record in a subform, currently the subform
record dissapears when you're creating a new record on the main form