Two tables, one query, one form, one problem

[Guest]

Hello all:

I have two tables (one with employee data and one with Office location
data). They are joined using the office address as the primary key in the
Office Table and the foreign key in the Employee Table.

I have created a query using all of the fields in each table.

Here is what I want to be able to do (and can't seem to):

Enter in new employee data and (with a combo box) select the address of the
office and have it populate the rest of the office information.

When I try it, it doesn't work. I have created a query with the addresses
and bound it to the combo box. I get the error message "The Microsoft Jet
database engine cannot find a record in the table 'Office_Table' with the key
matching field(s) 'Employee_Table.Address'."

Please help!! Thanks

huber57

 

[Guest]

Nevermind. I figured it out.

 

[Tom Lake]

Nevermind. I figured it out.

Now if only *we* could figure it out!

Tom Lake

 

[ella]

Could you please post the answer?