Access 2K ........

Hi there,

I have a little problem: And hope somebody can give me an answer.

I have two tables, one form and on the form I have two textboxes. One of the textboxes should be connected to ONE table and field, and the other textbox to the OTHER table and field.

I tryed to conect through the expression builder but had not much luck! See code below.

Code:

---

This code comes up in the ControlSource property section and textbox also:
=[tbl_CompanyContact]![CompanyPhoneNumber]
=[tbl_PrivateContact]![PrivatePhoneNumber]

---

Where do I set in properties the connection to different tables i.e. tbl_CompanyContact / tbl_PrivateContact and where the connection to the field CompanyPhoneNumber / PrivatePhoneNumber.

Thanks aktell

Click in the grey area inside the window but not on the for or on the form (can't remember which).
Properties>Data Tab - specify the tables (preferably with a join) to get the data from



OR


Use Code to fill the textboxes - but that would be up to you and depends on what you are doing.