I have a subform on a main form. Subform is used for data entry into a transaction table.
Subform has a textbox that does dlookup on an ID field from another query. It works fine when I open up the subform on its own. When I open the main form and select the name based on which it is supposed...