By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,247 Members | 1,224 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,247 IT Pros & Developers. It's quick & easy.

Subform RecordSource query, records pulled

P: n/a
Hello,

Say that there is a database for client information; there is a main
form that displays the client's name, and this form has one or more
subforms that display different types of information related to that
client.

The main Form has RecordSource="SELECT clientid, clientname FROM
client_table;", and each subform has both Link Child and Master
Fields="clientid".
The actual subform (let's call it 'frmPhoneNumbers') Form has
RecordSource="SELECT clientid, .phone1, phone2 FROM client_table;".

My question is, when the subform is loaded, is the entire query
specified in the RecordSource property executed and then filtered for
"clientid" (i.e. all records from client_table are returned), or is the
query modified with a WHERE clause and then executed (i.e. one record
is returned)?

I will be converting an Access application to use a SQL backend, and
feel that this is an important question.

Thank you very much,
Robert Waters

Dec 21 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.