Choosing a form’s record source

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"alex" wrote in message
...
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

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

"alex" wrote:

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
.

On Mar 24, 10:18*am, GBA wrote:
I would hazard a guess that the majority of forms are sourced on a query for
all the reasons you list....



"alex" wrote:
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
.- Hide quoted text -

- Show quoted text -

Thanks for the help!
alex