Display query result

  • Thread starter Thread starter gavin
  • Start date Start date
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
 
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).
 
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
 
Back
Top