Navigating between forms

[Jeff]

I have a database where most of the activity takes place on the
demographic forms. There are a few instances where the user will need
to navigate to a separate screen, but infrequently. So I set up a
series of click buttons where the user can click on it and open the new
form. I am using a macro with "openform." This form has some
information on it, along with a subform.

However, when I do this, the demographic table associated with the form
is not being carried over to the new form. Is there a way to do that?
I'm thinking there probably is, but not using an openform macro.

Thanks.

[salad]

Jeff wrote:

I have a database where most of the activity takes place on the
demographic forms. There are a few instances where the user will need
to navigate to a separate screen, but infrequently. So I set up a
series of click buttons where the user can click on it and open the new
form. I am using a macro with "openform." This form has some
information on it, along with a subform.

However, when I do this, the demographic table associated with the form
is not being carried over to the new form. Is there a way to do that?
I'm thinking there probably is, but not using an openform macro.

Thanks.

Is it possible your demographic form has a new record, or an existing
record with modified data, that is not being saved prior to opening up
the new form.

Set runcommand/saverecord first prior to opening the new form.

[Rick Brandt]

Jeff wrote:

I have a database where most of the activity takes place on the
demographic forms. There are a few instances where the user will need
to navigate to a separate screen, but infrequently. So I set up a
series of click buttons where the user can click on it and open the
new form. I am using a macro with "openform." This form has some
information on it, along with a subform.

However, when I do this, the demographic table associated with the
form is not being carried over to the new form. Is there a way to do
that? I'm thinking there probably is, but not using an openform macro.

Thanks.

Your OpenForm command needs to include a filter for the form being opened. The
OpenForm method in VBA has an optional WHERE argument that does this. I have no
idea how that works in a macro as I never use them.

In design view of the demographic form you could add a new command button making
sure that the Toolbox wizard is enabled. One of the choices for the wizard does
exactly what you want.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com