Tab Control Page Issue

[Connie Northrop]

I have a form with a tab control with several pages on it. When the record needs to be edited you have to open a new form that is basically a duplicate of the main form. I need to have the edit form open showing the same page that is showing on the main form. I can’t use open args, that is already in use. Does anyone know a way to do this

Thanks

 

[John Vinson]

I have a form with a tab control with several pages on it. When the record needs to be edited you have to open a new form that is basically a duplicate of the main form. I need to have the edit form open showing the same page that is showing on the main form. I can’t use open args, that is already in use. Does anyone know a way to do this?

Thanks!

I'm not sure it's a good *idea* to do this. If you have the same
record open on two forms, the second form open will be locked and
unable to edit the record (because, as far as Access is concerned,
it's already open for editing on the other form).

This sounds like a cumbersome approach; may I ask why you're opening
multiple forms ("several pages") and then opening yet another instance
of the same (multipage?) form?

 

[Connie Northrop]

The edit page is only a copy of the record. We had to do this because letting users edit directly into the tables created too many errors. This way they can save their edits or not if they make a mistake. It is safer.