Hi,
I have form created(frmsearch) based on a query(qrysearch) which searches based on partial last name. For example when you run the query it asks the user for Partial Last Name, so when you type "smi" it returns two values on the form smith, john & smith, kathy.
And on this form next to each returned record, in this case "two" , is a command button(cmdplaceit).
When the user clicks on the button, I want a field on the form(txtname) corresponding with the button pressed, returned to another text box on frmmain.
Does anyone have any ideas how I can set this up?
thanks all
I have form created(frmsearch) based on a query(qrysearch) which searches based on partial last name. For example when you run the query it asks the user for Partial Last Name, so when you type "smi" it returns two values on the form smith, john & smith, kathy.
And on this form next to each returned record, in this case "two" , is a command button(cmdplaceit).
When the user clicks on the button, I want a field on the form(txtname) corresponding with the button pressed, returned to another text box on frmmain.
Does anyone have any ideas how I can set this up?
thanks all