Need second form to open on same record

[Chris Krutzler]

I have two forms I'm working with (both posting data to the same table). What I need is to be able to click a button on the first form and have it open the second form to the same record number as the first.

I can get the second form to open, but it jumps to either a new record or the first record. Is there a way to get it to stay on the same record number?

Thanks

 

[Steve Schapel]

Chris,

What you are doing is very unusual. In fact, I have never seen it done
before. Why are you simultaneously using 2 forms bound to the same
table? It's theoretically possible, but is likely to be fraught with
difficulty regarding record locking, data updating and saving issues,
etc. If it's because of form "real estate" considerations, a good way
to handle this is to use a Tab Control with some of your data controls
on one page of the tab control, and the rest on another. If I have
missed the boat here, please post back with some more information about
your data and what you are trying to achieve, and someone will be able
to advise.

 

[Chris Krutzler]

It is a real estate issue. What I have is a data entry form that has fields that may or may not be used when putting in data. I want the optional fields to come up on the same record number as the required fields. I tried you thought of a tab handler, but I'm still running into the same problem. Do I need to run the forms from two different tables?

 

[Steve Schapel]

Chris,

You are still talking "forms" plural. My suggestion is to use one form
bound to one table. You can have as many pages as you like on a Tab
Control, and this is usually an adequate means of handling the type of
situation you have described. I am not clear what you mean, therefore,
when you say "still running into the same problem"... Maybe it would
help if you could give some more details with examples.