I have two combo boxes on a form, can get them to sync fine but when I movefrom record to record I loose the contects of what was selected. For example I have a Category combo that filters selections in a Product combo. IfI enter a new record with a different category and select a product accordingly, the first record removes the product and the field is blank.

Any ideas as to a fix would greatly be appreciated.

Ok I figured it out. Needed to put a requery statement on the OnCurrent Event of the form and that worked great.

Ok even more weird works if in Form View only, on DS or Continuous forms the product combo box is blank on all records but the active record?

Any explanations or work arounds would greatly be appreciated.

vvariety <vvariety816 (AT) gmail (DOT) com> wrote in
news:6589eca0-9268-4047-8c56-2128e1e097bd (AT) glegroupsg2000goo (DOT) googlegro
ups.com:

This is because the rowsource doesn't include the value that is set
in the bound field, so it can't display it.

This is one of the problems with editable datasheet/continuous forms
-- if you have conditional dropdown lists, you'll always have this
problem. That's why I generally don't make these forms editable when
there is conditional display of information in the controls. Once
it's not editable, you don't need a combo box at all -- just display
the data.

For editing, you can have another subform with a single form that
displays the detail of the record selected in the
datasheet/continuous form.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/