Add text from different table

[hithere]

I have a form with the control souce Info table. This table includes Cmpyname, number, address, start date, and phone number.

I would like to add a text box that retrieves a date from my CMS table. The CMS table has a name field(looked up from the Info table) update field, and date field.

Combining the tables into a query will not work because there are several other fields on the form that only apply to one table.

Is there any way to add a text box to a form from another table or query?

[pbaldy]

Is this what you're looking for?

http://www.baldyweb.com/Autofill.htm

[RuralGuy]

You can use a DLookup(). Do these two tables share a relationship of some sort? Do they have a field in common?

[hithere]

The two are joined by name. Cmpyname from the info table and Name from the CMS table. The Name field is looked up fromt the Cmpyname field.

[hithere]

pbaldy this is somewhat what I am looking for. I would like for the values to appear in the text box based on whatever record is displaying. I.e if I the record at the bottom displays record one the assoiated information should come up without having to select it from a combo box.

[pbaldy]

Presuming the combo row source contains the fields, the

=ComboName.Column(x)

method should work.