Synchronized Combo Boxes on Embedded Form

[Rose Lentz]

I have two combo boxes (cboDisciplineSelect and
cboLevelSelect). cboLevelSelect is a filtered list
depending upon the selection made in
cboDisciplineSelect. To the right of the combo boxes I
have read only fields which show the descriptions of the
code stored by each combo box. For example, to the right
of the cboLevelSelect combo box is a read only
field "[cboLevelSelect].[Column](1)"

The combo boxes are on a continuous form (EntriesForm)
that is embedded on a Page/Tab placed on my primary form
(Main).

The combo boxes function properly when entering data;
i.e., the cboLevelSelect list is filtered appropriately
depending upon the choice made in cboDisciplineSelect.
(I am using "requery" on cboLevelSelect to reset the
focus.)

For those previous records where cboDisciplineSelect is
different from that entered for the current record,
[cboLevelSelect].[Column](1) disappears from the screen.

How can I avoid losing the description of the codes
stored by cboLevelSelect?

 

[tina]

change the read-only text box's ControlSource from

=[cboLevelSelect].[Column](1)

to

=DLookUp("[DescriptionField]","LevelsTable","[LevelIDField] = " &
[Forms]![MyFormName]![LevelIDFieldOfCurrentRecord])

hth