While you are choosing fields after linking a table to your form, there is an option to see all tables and put in my form whichever field in whichever table I want. This automatically creates a query as a record source. Is this an okay way to design forms or will I get into trouble later on for not having properly named and saved queries for all my forms?
Adam Schwanz
@Reply 4 years ago
I'll let someone else answer to about if how you're doing it is OK, because I'm not really following what you're doing.
However, you don't need saved queries for all your forms, the ones you do have should be properly named yes. If it's a query you're going to use a lot then sure make a query for it, and at the beginner level just make a query for everything. But once you get later on in the courses and start to learn SQL, you don't always need to make a query for everything. It will save you some clutter if instead of making a query to limit criteria you can instead just type right into the record source something like Select * From CustomerT Where CustomerID=1 or whatever situation you were making a query for. Queries are just a pretty way to make SQL statements, if you go to the view button on a query you've made and pick SQL view, you can see the SQL that makes up that query, and if you wanted to, you could just copy that text and paste it into your record source
Adam Schwanz
@Reply 4 years ago
Then delete your query, although I wouldn't suggest doing that until you are further along. Just some information for you for later :)
Mo Albedah
@Reply 4 years ago
What are the odds? I just covered that in Access Expert level 3, video 1 SQL Primer.
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 Beginner 2.