If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Choosing a form’s record source
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 |
#3
|
|||
|
|||
Choosing a form’s record source
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 . |
#4
|
|||
|
|||
Choosing a form’s record source
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 |
Thread Tools | |
Display Modes | |
|
|