Access 2K Manualy Connecting........

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.


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