Navigating to another form

[Jeff]

I have a form which has a command button to bring up a second form.
The command button uses a macro, OpenForm with a filter of [Forms]!
[SignUp]![EventID] to take it to the 2nd form and open it on that
record.

The problem occurs when I try to use a combo box on the 2nd screen to
change the data. I have it set up like several others in the database,
but it doesn't work. Is it because of the filter I'm using to navigate
there? Is there a way around that?

Thanks

 

[Jeanette Cunningham]

Hi Jeff,
very often we design a search form and then use to open a details form at
one specific record. When user has finished with the details, they close
the details form and do a new search for the next record.

I suggest that you use this system. User opens the second form to a
particular EventID.
When finished with that one, let them close the form which takes them back
to the search form where they can choose a different event.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia