I am stumped on the issue below, and would greatly appreciate any thoughts on a solution:
--> I have a main "project" form with a subform that lists project participants.
--> The subform pulls its data off a query based on a participant information table and includes a "participant name" field, which is a combo box.
--> Participant records can be configured to not display in the combo box list. When this is done the participant in question does not display on previously created records. I have previously addressed this sort of issue on forms (not subforms) by adding an additional "name" field to the query underlying the form, and displaying this on the form in a text box overlaying the combo box.
--> I have tried the same approach with the subform I am working on. Everything seems to be working, except that when I bring up the main form, the text box that is supposed to be overlaying the combo box on the subform gets hidden underneath the combo box. I have tried everything I can think of but cannot get this to change. As additional information, when I open the subform by itself, the text box appears over the combo box as planned. So it is only in the context of opening the subform within the main form that the text box gets hidden below the combo box.
I hope the above is clear, and sorry if it is a little long-winded, but thank you in advance for any help.