Choosing a form’s record source

[alex]

Choosing a form’s record source

Hello,
Using Access ’03…

I’m looking for some expert advice on using a query (more specifically
a SQL statement) as a form’s record source.

I just realized that you could do this a few months ago.

As long as it fits your needs (editable if you need to edit, etc.); I
don’t see why you wouldn’t in place of a table (better sorting/
filtering) or a query object (less clutter/more dynamic).

I’m probably missing something.

Thanks,
alex

 

[Allen Browne]

Do it.

Using a SQL statement or a saved query as the RecordSource for a form or
report makes good sense.

 

[GBA]

I would hazard a guess that the majority of forms are sourced on a query for
all the reasons you list....

 

[alex]

I would hazard a guess that the majority of forms are sourced on a query for
all the reasons you list....











- Show quoted text -

Thanks for the help!
alex