Create your query with all the appropriate fields; including any primary and
foreign keys.
Create a calculated field that concatenates your two fields in an empty
column: Such as FirstName and LastName.
FullName:[FirstName] & " " & [LastName]
In the criteria section type: Like [Enter First and Last Name] & "*"
The & "*" Allows to enter a partial name in the event the user can't
remember how to spell a name. Also pressing Enter without entering any data
will return all names.
On the subform you can create a textbox control and set it to =[Enter First
and Last Name] and it will print the value entered by the user.
Note: Subform data is returned based on one or more related keys in the main
table. If you are trying to return data in the sub form separate from the
main form, this will not work. You have to call mainform data to get the
related subform data.
Perhaps if you run through the motions of what you are wanting to do; a
better more productive answer can be given.
