Display query result

G

gavin

I am sure this is a really stupid question but I have to ask it anyway :)

When I build a simple query and run it the result is always in datasheet
view. Is it possible to view the results in form view (I have created a form
for the underlying table) - rather like when you use the Filter command?

Regards,




Gavin
 
F

fredg

I am sure this is a really stupid question but I have to ask it anyway :)

When I build a simple query and run it the result is always in datasheet
view. Is it possible to view the results in form view (I have created a form
for the underlying table) - rather like when you use the Filter command?

Regards,

Gavin
Click to expand...

Sure.
Simply create a form and set it's record source property to the query.
Then open the form (not the query).
 
G

gavin

fredg said:
Sure.
Simply create a form and set it's record source property to the query.
Then open the form (not the query).
Click to expand...

Wow - that was quick!!! Thanks very much for that, Fred - I'll give it a
go!!!



Regards,



Gavin
 
Top