Using QBF to open a form rather then a table

[LC85]

Hello,

I created a QBF based on queries that the user can search by, at the moment my QBF has a command button that finds the record in a table veiw. What i'm trying to achieve is to be able to create a command button that finds the matching records on a main form (with all records) I created.....

Please Help...

LC

 

[ajetrumpet]

Hello,

I created a QBF based on queries that the user can search by, at the moment my QBF has a command button that finds the record in a table veiw. What i'm trying to achieve is to be able to create a command button that finds the matching records on a main form (with all records) I created.....

Please Help...

LC

LC,

In general, finding records within forms (that have recordsources, that is) can be done by using the find or seek actions. I use findfirst and findnext a lot when I'm dealing with forms. Check out the syntax for those. I use them in combination with the "recordsetclone" and "nomatch" properties to search forms.