General discussion
January 29, 2004 at 07:07 AM
carljohnman

Access 2002 Forms Passing ID’S

by carljohnman . Updated 22 years, 8 months ago

I created a new table (FileHolders) and a new form (FileHolders1). Problem 1: My goal is to have this form open only when another form (CreateSearch)which stores its data in another table (Search) is opened. Problem 2: After I accomplish this I want form (FileHolders1) to open to the id number the other form (Create Search)is currently on by default. Summary: The new form (FileHolders1) should never open unless form (CreateSearch) is open and when it does open it is set to the id of form (CreateSearch) by creating a new record in its own table. I am a novice and if you can help which would be greatly appreciated please explain if you have time.

Thank you very much for any assistance,
Carl Johnman

This discussion is locked

All Comments