I have a look up and after I select a record from the look up box I have it open a form that includes a the records queried. I want the form to open up with the record I selected from the look up in the form.
Let me give an example I do a look up for everything scheduled for a certain date. I found 15 records shown in the look up box and I select the 7th record on the click property I have it set to open a new form which has all the 15 records found. I want this form to remember and to open with the 7th record that I selected from the look up box.