Hi All
Not sure how to phrase the thread subject better than the above as i'd probably end up writing most of the paragraphs coming as the subject.
Anyway
I'm trying to understand if there is any discernible difference between the following 2 options for a forms Record Source.
Option 1
If i create a query separate to the form which returns the records i require and then when building a form i use the query as the record source
Option 2
I create a form and use a few tables as its record source and then drill into the record source and build the same query from option 1 in there
I hope this question makes sense, i am still learning (we probably all are i guess but i'm still in the early stages of learning here) how to do things more efficiently as with my FE/BE setup i want to reduce the overheads where i can for the users.
Thanks in advance
Glen
Not sure how to phrase the thread subject better than the above as i'd probably end up writing most of the paragraphs coming as the subject.
Anyway
I'm trying to understand if there is any discernible difference between the following 2 options for a forms Record Source.
Option 1
If i create a query separate to the form which returns the records i require and then when building a form i use the query as the record source
Option 2
I create a form and use a few tables as its record source and then drill into the record source and build the same query from option 1 in there
I hope this question makes sense, i am still learning (we probably all are i guess but i'm still in the early stages of learning here) how to do things more efficiently as with my FE/BE setup i want to reduce the overheads where i can for the users.
Thanks in advance
Glen