Referencing the 1 side of a 1-Many Relationship (Access 2000)

[WSC]

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,
=tblA.[fieldname]?

Thanks.

[charlotte]

No. The only way to reference a field in a table is through a dlookup or by opening a recordset on the table. Of course, you could use a combobox on your form and bind it to tblA. Then you could automatically display a related value in the combobox.

[WSC]

Thanks for the reply.

I've left it with the dlookup as the control source. It works fine although it does take an extra nanosecond to do the lookup and fill in the field!