You don’t need a pop up form. You can build a small unbound form having one input field (confirmation number) and a fetch button.
Your primary form, the one containing all your information should be bound to your primary table.
On the on click event of your fetch button, include something like the following…
Docmd.openform “primaryform”,,,”key = ‘” & me!confirmnbr & “’”
Remember to set your small unbound form to open at start up.
Robert Berman