AboutRichard Rost Expertise I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site.
Education/Credentials I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com
Thank you very much again for your help with my last VBA issue. Now I have a more general question.
In my last question you explained how to reference a particular field in VBA to run an Update query using SQL. Now I have have a question regarding using VBA to pull up forms. I understand the basic DoCmd function, but if I have a form that is dependant on a query which requires certain values to be input, how can I tell access to use a certain field for these required values.
For example, if I have a form that requires me to enter the effective date and plan number (because of the underlying query) how can I tell it to look for these values in a field on a separate form?
Thank you!
Answer Just use Forms!FormName!FieldName notation for the criteria in your query.
Let's say you have a form named CustomerSelectF with a combo box called CustomerCombo (based on CustomerID field). In your query, you would simply have this as the criteria for your CustomerID field:
P.S. Come and try one of my ACCESS TUTORIAL VIDEO LESSONS on my web site FREE. Just use this link. http://www.599cd.com?AEXAC
P.P.S. Remember, I volunteer my time at AllExperts to help people, so I can't take 20 minutes to answer each question. If you need more DETAILED HELP, come to my TechHelp web site at http://www.599cd.com/TechHelp and I'll take as much time as you need to answer your question.
