Invoking a query using button and displaying on subform

[.]

Hi, I am pretty new to access hope you guys could enlighten me.

I have this button that invoke a simple search query and a subform. How
do i actually display the result of the query inside the subform.

 

[Allen Browne]

Wow. There can be a lot to that question: how to offer several boxes, but
not apply criteria on the ones the user leaves blank, how to handle
different data types correctly (numbers, dates, text), how to allow partial
matches, how to handle ranges (e.g. a month or year), ...

See:
Search criteria
at:
http://allenbrowne.com/ser-62.html
The article includes a sample database to download and see how it works.

 

[Larry Linson]

"." wrote

I have this button that invoke a simple
search query and a subform. How
do i actually display the result of the
query inside the subform.

You don't run the query and then display the results in a Subform -- you
make the Query the RecordSource of the Form embedded in the Subform Control,
and requery the Subform Control.

Larry Linson
Microsoft Access MVP

 

[.]

thanks guys... will try it out tml....

 

[.]

hi, regarding the requery the sub form control how do i go abt doing it?