2 combo boxes

  • Thread starter Thread starter Maracay
  • Start date Start date
M

Maracay

Hi Guys

I Have 2 combo box the first is clients and the second one is materials,
what I want is to select the client with the first combo box, but when I
select the second combo box for material I just want to see the material
assigned to the client I previously create, I have a query with clients and
material and the criteria is [forms].[frmOrders].[ComboClientName] and I
place this query as row source in combo box material, but is not updated when
the client change, I will really appreciate if someone can help me with this.

Thanks
 
Unless you tell Access to refresh the source for the second combobox, it
won't do that.

In your first combobox's AfterUpdate event, add something like (untested):

cboYourSecondCombobox.Requery

Use the names of your comboboxes.

Good luck!

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Thanks, it works

Jeff Boyce said:
Unless you tell Access to refresh the source for the second combobox, it
won't do that.

In your first combobox's AfterUpdate event, add something like (untested):

cboYourSecondCombobox.Requery

Use the names of your comboboxes.

Good luck!

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Maracay said:
Hi Guys

I Have 2 combo box the first is clients and the second one is materials,
what I want is to select the client with the first combo box, but when I
select the second combo box for material I just want to see the material
assigned to the client I previously create, I have a query with clients
and
material and the criteria is [forms].[frmOrders].[ComboClientName] and I
place this query as row source in combo box material, but is not updated
when
the client change, I will really appreciate if someone can help me with
this.

Thanks
Click to expand...


.
Click to expand...
 
Back
Top