requery issue when combo box values set by another combo box value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pubdude2003 - 04 Jul 2007 21:52 GMT

I am experiencing a problem when assigning values from one combo box to
another. When I want to clear the newly assigned values I simply requery the
combo box (single form so no issues there) but it refuses to requery. The
orginal values for the combo are set when the form opens. Should the requery
not ask for the original rowsource set by the control properties for the
combo box or does it just requery based on the new rowsource assigned by the
other combo box|?

Reply to this Message

Steve - 05 Jul 2007 00:02 GMT

Your second combobox gets its values from a query that has the value of the
first combobox as a criteria in one of the fields of the query. If you don't
change the value of the first combobox, you will always get the same set of
selections in the second combobox.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@pcdatasheet.com

>I am experiencing a problem when assigning values from one combo box to
> another. When I want to clear the newly assigned values I simply requery
[quoted text clipped - 6 lines]
> the
> other combo box|?

Reply to this Message

Beetle - 05 Jul 2007 22:34 GMT

Perhaps you could clarify. Are you saying that the values in combo box 2 do
not update when you change the value in combo box 1? If so you simply need to
put the following in the after update event of the 1st combo box;

me.combobox2.requery ("combobox2" being whatever the name of you 2nd combo
box is)

> I am experiencing a problem when assigning values from one combo box to
> another. When I want to clear the newly assigned values I simply requery the
[quoted text clipped - 3 lines]
> combo box or does it just requery based on the new rowsource assigned by the
> other combo box|?

Reply to this Message

pubdude2003 - 21 Oct 2007 16:49 GMT

sorry Beetle, Steve, just realized that I completely ignored your kind
responses... in case you are monitoring still... thanks!

I just put in some code to refresh the entire form including the default
values of the first combo... seems so simple now... musta been drunk then

Reply to this Message