Hello All,
Does anyone have a good example of a search result list and when the user click on a row it will open up that record? I tried searching but can't find a good example that will illustrate how to do it.
Example: On the main form there's two text fields "A" and "B". The user type in something in "A" and "B" and clicks search and Access returns with a list (like a subform underneath with columns "A" and "B") of all the matching records. When a user click on a WHOLE ROW, it will open up another form displaying the record highlighted.
Is this possible?
THanks in advance.
-Lory
Does anyone have a good example of a search result list and when the user click on a row it will open up that record? I tried searching but can't find a good example that will illustrate how to do it.
Example: On the main form there's two text fields "A" and "B". The user type in something in "A" and "B" and clicks search and Access returns with a list (like a subform underneath with columns "A" and "B") of all the matching records. When a user click on a WHOLE ROW, it will open up another form displaying the record highlighted.
Is this possible?
THanks in advance.
-Lory
