I have a form which tells the user that data is missing from certain job requests ids. I want the user to double click on the request id and have the original form open so they can fix it. I have bound textbox called Request ID field that contains the value I want passed back then matched to original form. My problem is the Request ID field on the original form is an unbound list box where the rowsource is SELECT SalesTest.[Request ID] meaning the user clicks a job in the list box and it changes the form's values. How can I do this? The form opens but the record is not matched.
Here is my code now on the Request ID double click event:
Sorry, I missed the code change you provided but I just tried it. Same problem - the original form opens but list box does not go to request id from the other form. It goes to the most recent request. I want the user to double click on the request id on the Data missing form and find the match on the original so they can fix the information. Since the fields are both unbound, can I match by column like below? I tried this but it does not work: