Two forms that work off of 1 table 1

[jminn0311]

I have a main form with part of the table's info located on it and another form that pops up under certain conditions. Both forms are linked to the same table.

What i need is for the pop up form to be on the same recordset as the main form when it pops up. I know this is a simple question but it really has me baffled.

Thanks in advance for any help.

Jeff

 

[lupins46]

The docmd.openform statement allows you to specify the record(s) you want to see. Look at Help.

If the pop-up is based on the same table as the main form, you will have to save the main form record before opening the pop-up otherwise you are going to get into a locked record situation.
Use
me.dirty = false
before the Docmd.Openform statement.