Combo Box Problems

[Guest]

I am trying to create a continuous form with several combo boxes in it.
First combo box contains a list of items.
Second comb box will display different information based on what is
selected in the first combo box.
Third combo box will display information based on what is chosen in the
second combo box.

The problem I have is when I start entering information in the second row of
the form, the information already entered in the first row will disappear. It
is still in the table, but it is missing from the form.

Any suggestions?

 

[Tony Vrolyk]

This is a limitation of continuous forms and datasheets and a side effect of
how combo boxes work. When you change a property of a control on a
continuous form or datasheet, it changes that property for all instances of
that control -i.e. for all records displayed. So in your case you are
changing the RowSource of a combo box while in one record and in so are
doing it for all records.

Since a combo box will not display it's data unless that data is part of the
row source, combo boxes in previous records may appear blank. As you have
already noted the data is not lost just hidden.

I will bet that if you keep playing with it you will find that in a case
where you are making a select that if the RowSource happens to be
appropriate for some other record then the combo box will not appear blank
(i.e enter data in one record substantially similar to another record)

I have just had to train my users that in datasheet view (I don't use
continuous forms that much) they may see fields disable or clear at odd
times but that when the click on that record again it will return to normal
(in my case the changes happen OnCurrent)

Since you are working with Combo boxes you might get away with setting the
Limit To List setting to No. Then I believe the data will still be
displayed. However then you open up the possibility of wrong data being
entered because users won't be forced to select from the list.

Tony V