Contact selection

[screech63]

I have three tables, tSales, tCustomers and tContacts. I have created a form that lists the Customers name and address details. I have then created a subform for entering the contacts details for managers associated with this customer. Works ok.
I then created a Sales form from which you select the customer and it shows the company name, in the next field, I have a combo going back to the contacts but instead of showing only the contacts for the previously specified company, it shows all contacts in the contact list. How do I make it only show the associated contacts?

[Welshgasman]

You need a Where in the combo source.

[screech63]

What would the Where statement be and in which combo source.
tContacts is linked to tCustomers by CustID.

[Welshgasman]

Either refresh the source in the afterupdate of the Customer combo with the WHERE criteria , or in the query source for the Contacts refer to the form control as criteria hardcoded. You could even use a TempVar in the query and just set that in the afterupdate event?

As with most computer issues, several ways to skin a cat.
Most people would start with the form option. Then if they need that query source for a combo in another form, parameterise it, either dynamically or a TempVar

Using the form control option.
https://docs.microsoft.com/en-us/off...-qbf-technique

[mike60smart]

In the Row Source for the Combobox for selecting a Contact you need criteria as shown below:-


Then in the AfterUpdate of the Combobox for selecting the Customer you need to put the following:-

Me.[NameofContactCombobox].Requery

[screech63]

Thanks Mike, still struggling with it. Keep getting an error.

What I need is someone knowledgeable in North Herts so I can sit down and go through what we require.

[Welshgasman]

Thanks Mike, still struggling with it. Keep getting an error.

That is as much use as 'how long should my string be?'
Report what the error is, not just the number, but the description.

[ssanfu]

You **could** make a copy of your dB, change the names to cartoon characters, change any sensitive data and post the dB.

[Welshgasman]

Here is moke123's utility
Randomizer
See post #19 for a way ro randomize your data for upload


https://www.accessforums.net/attachm...0&d=1613310673

Micron also has one here as well.