Choosing a form’s record source

  • Thread starter Thread starter alex
  • Start date Start date
A

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
 
Do it.

Using a SQL statement or a saved query as the RecordSource for a form or
report makes good sense.
 
I would hazard a guess that the majority of forms are sourced on a query for
all the reasons you list....
 
Back
Top