This may be easy, but I trying to create a form that searches the table and then once that data is returned have a button to take that data and put that into a form to add a new record.
I want to take certain data...name and address, ect and use this to enter a new record. Don't want user to enter data twice just to reuse same data.
How would I be able to do this? I have a form that has an unbound control and a subform that requeries that data which is linked to the main form's control...this pulls the data and shows it to me. I want then to take that data....name and address, phone #, license information and put that into a new form to enter a new record but without entering that data again....just have the fields populated for a new record.
Thought maybe I can just create a form that links the fields
would this be the best way?