Search information using the main form

[Guest]

I am making a access db with a main form and linked a subform.
I can show the record by entering the primary key in the main form and the
subform will show the relevant information --- that is ok!
But i try to enter infomation in the other text box in main form but no
action only the table content changed! ---- problem
How to use the other text boxes to search the record and the result can be
seen in main form and of course related record will be shown in the sub-form
as using the primary key.
How to prevent the content to be changed as mentioned but only after the
button will created later to add, edit , del record... etc.
Really thankful for any your help!
Fred Ho

 

[Arvin Meyer [MVP]]

You don't mention which version you are using, so the menus may be
different. Right -click in the control you wish to search and the click in
the "Filter for" box. Enter your search criteria, which can use a wildcard
(like: micro*), then press the Enter key.

 

[Guest]

In fact i am using the form as an interface for the user to search
information as mentioned, so I wouldl like the main form will be able to show
the info. which matched the user input in the text box in the main form and
do not amend the table content. The filter function i think not what I want.
The sub form content can be search as I change the ID in the main form that
is right but how to make query using the other fields( the text boxs)in the
main form?
for adding,changing and del function I will ass buttons for them.
Thanks for any help!