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

How to extract a record from other Table to display on main Form

P: 1
I have a main Form Order Entry. In the customer field, I create a comboBox to query Customer Table records so I can select the name.

How do I reference back the customer name selected, extract the customer info from Customer Table and assign or display all the relevant fields on my main Form? Like contact, currency, delivery address and etc.

So these info will be save in the Order Table.

Thank you in advance for your help.

Regards,

chwong
Oct 3 '08 #1
Share this Question
Share on Google+
2 Replies


puppydogbuddy
Expert 100+
P: 1,923
You need to create a query that pulls those fields from the tables involved, and set that query as the form's recordsource. Once you do that, you will be able to bind the form controls to fields in the tables.
Oct 5 '08 #2

puppydogbuddy
Expert 100+
P: 1,923
Forgot to add that the afterUpdate event of the combobox can be used to determine which record to display on the form. If you need more help, please post the sql that you have for the form's recordsource query and for the combobox's row source.
Oct 5 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.