Field in form not always populating

[Jonah]

I have a form that I use to categorize info. As I
categorize info with comboboxes that get info from lookup
tables, the underlying table is updating correctly.
However, as I revisit records, one category in particular
fails to consistently be visible in the form.

The combobox that is not populating is a box that when
entering data displays categories dependent on the entry
in a previous box. When I initially enter the data, this
relation works well, but when I move on to another record
and return, the second combobox is no longer indicating
what was previously entered with one obvious exception.
If the selection in the first combobox is "Environmental"
the second box is populated.
But, as I said, the underlying table has the appropriate
information.

Any help would be much appreciated.
Jonah

 

[Marshall Barton]

I have a form that I use to categorize info. As I
categorize info with comboboxes that get info from lookup
tables, the underlying table is updating correctly.
However, as I revisit records, one category in particular
fails to consistently be visible in the form.

The combobox that is not populating is a box that when
entering data displays categories dependent on the entry
in a previous box. When I initially enter the data, this
relation works well, but when I move on to another record
and return, the second combobox is no longer indicating
what was previously entered with one obvious exception.
If the selection in the first combobox is "Environmental"
the second box is populated.
But, as I said, the underlying table has the appropriate
information.

It sounds like you're using code in one combo box's
AfterUpdate event procedure to synchronize the other combo
box. If so, you need to run the same code in the form's
Current event procedure.

 

[Jonah]

Thanks! That seems to work.

-----Original Message-----



It sounds like you're using code in one combo box's
AfterUpdate event procedure to synchronize the other combo
box. If so, you need to run the same code in the form's
Current event procedure.