I have a search (invoice) button on each line of the subform. When the search screen is open, user selects an invoice which should return on the invoice number field of the row where search buttom was pressed. In the search screen, I have the following code
I can see the invoice number populate on the subform but if I add a DoCmd.Close line, the invoice number does not save. If I have code as stated above, and then close the form using another button (Cancel), I get result I'm looking for. But I don't want to have to press cancel to close. Any ideas?