Open a Second Form on Check

[Hey Lucy]

I have a form that has a checkbox on it. The default is False. I need to open another form if the checkbox is checked (True). I can do that but how do I get the 2nd form to open to the specific record in the main form?

 

[Mr. B]

Use the "Where" parameter of the OpenForm method.

If you are using VBA or a macro there is an option to add the criteria to open the form to a record meeting the criteria you provide.