Need second form to open on same record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris Krutzler - 28 Jul 2004 18:15 GMT

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

Reply to this Message

Steve Schapel - 28 Jul 2004 21:24 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> 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
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Chris Krutzler - 29 Jul 2004 13:40 GMT

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?

> Chris,
>
[quoted text clipped - 19 lines]
> >
> > Thanks

Reply to this Message

Steve Schapel - 29 Jul 2004 20:40 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> 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?

Reply to this Message