I have two tables: tblA and tblB. There is a 1-many relationship between them - i.e. one record in tblA can have many records in tblB. I also have a form, frmC, which uses tblB as its recordsource, with a filter. I know that I can reference a field from tblA in frmC by inserting a dlookup in the control source of the text box. I have done this and it works. I also know how to do a dlookup in the Form Open event to accomplish the same thing.
My question is: Is there a way to directly reference the field from tblA, as in, for example,