Currently, I have two separate forms/subforms to help me enter data. The main difference on the two forms is that depending on one record on the main form, the combo list on the subform changes. Would it be possible for me to create a single form, enter the variable value on the main form and then, based on this value, the subform choose between two different combo boxes?
Having two forms is not horrible but I often have to switch back and forth between main forms which is cumbersome.
Thanks for your input,
Greg