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