Could you have also made the LetterActiveR with an
Joe Beniacar
10 years ago
Could you have also made the LetterActiveR with an SQL statement based on the CustomerT with a WHERE condition about IsActive being True (If you didn t want to make a separate Query)?
Reply from Alex Hedley:
Yes you could, but it's sometimes neater to have a saved Query, and easier to see what you have set, if you have to go into the RecordSource and look into the SQL it gets a little bit fiddly. A Query doesn't take up much memory and although your db can grow in size with the number of objects, Rich does teach in later classes how to use SQL strings or VBA to slim down the number of objects in your Navigation Pane.
LetterActiveR is based on CustomersActiveQ which is CustomerT with a Criteria of IsActive=True
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 6.