Find Record Button not working on subform

Quasius

Registered User.
Local time
Today, 05:01
Joined
Jul 30, 2002
Messages
13
I am trying to add a "find record" button to a form. I just used the command button wizard to make one. It works fine to locate a record with a certain value in a selected field in the main form, but it does not work in the subform. If I select a field in the sumform to search for a value in, it always says that it cannot find that value, even though it is there. Is there something special you need to do to get a search buton to work on a subform?
 
You're probably using the wrong criteria on the search. Test your criteria in a query with your form (and subform) open. Then replicate that query in your code behind the button.
 

Users who are viewing this thread

Back
Top Bottom