how to retrieve records from access database and show in a form

[willi]

I have created an access form whose records are stored in 2 tables and i have
inserted second table as a sub sheet into the main table .If i enter a
subject number in a text box and hit a search button i should get all
records from database and display on form

 

[Allen Browne]

See:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html

You are using a subdatasheet instead of a subform, but it still works the
same.