AlastairOz
Technical User
I have a form set with 2 forms.
Form1 main form
Form2 look up
Form1 has a search box where you type in an ID and it will go to the required record.
If the user does not know the ID number then I have made a look up with form2.
Form2 ends up with a value.
At the moment I pass the value to a text box on Form1 eg
thisformset.NEWDEFECTS.txtbox4.Value=thisform.txtAssetFind.Value
I tried passing this value directly to Form1's search text box. This does not work, as the text box is looking for the value to be typed in.
Not really sure how to progress, any help would be appreciated.
Form1 main form
Form2 look up
Form1 has a search box where you type in an ID and it will go to the required record.
If the user does not know the ID number then I have made a look up with form2.
Form2 ends up with a value.
At the moment I pass the value to a text box on Form1 eg
thisformset.NEWDEFECTS.txtbox4.Value=thisform.txtAssetFind.Value
I tried passing this value directly to Form1's search text box. This does not work, as the text box is looking for the value to be typed in.
Not really sure how to progress, any help would be appreciated.