Disappearing Data

  • Thread starter Thread starter Kevin Sprinkel
  • Start date Start date
K

Kevin Sprinkel

On opening a data entry form w/one subform, the Row Source
of combo box 2 is set to the values of an entire table.
After updating combo box 1, 2's Row Source is then
filtered by combo box 1's value.

I found that if I deleted one or more records, or
previewed a report from a command button on the main form,
combo box 2 no longer displayed values where the combo box
1 value was different than the current combo box 2 Row
Source.

I tried using the OnGotFocus and OnLostFocus events to set
the RowSource to the filtered data and the entire data,
respectively, but I found that in pressing the report
command button, combo box 2 never loses the focus.

My goals are simple--display the combo box 2 value for all
records, and when in the combo box for data entry, have
its RowSource filtered by the value of combo box 1.

Can anyone help?

TIA
Kevin Sprinkel

I guess I don't understand event sequences well enough to
know in what event I could
 
Back
Top