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

How can I use a combo box to display specific customer records from my form

P: 1
Most of the web sites only provide examples of forms to display only one record. I want to display all records of the customer entered inside the combo box
May 23 '19 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,426
That should be simple enough. Simply set the DefaultView property to Continuous Forms.
May 23 '19 #2

P: 14
if I understand your question right, that you like to use the combo box to lookup a customer and all the records that is related to that customer.

in this case,

create a form with continuous form type as subform, to show all the records. then bring the subform into the form where combo box is. link it by the customer name field. this way, when you use combo box to lookup any customer, all the record with same customer name will listed in the subform.
May 23 '19 #3

Expert Mod 15k+
P: 31,426
That's a workable, and very popular solution, in fact.

However, it's more complicated than you need. There's absolutely no requirement to involve a separate form as a single one does the job for you perfectly well.

Remember the KISS principle.
May 24 '19 #4

Post your reply

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