Disappearing Data

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box 0
Split form 0
Macro doesn't work first time form is opened. 2
Combox not getting into edit mode 5
Disappearing Data 2
2007 Multi Value Check Box Lists 1
my combo boxes 2
Looking up 2 combo boxes and then calculate another field 1

Top