I have created a Combo lookup box as many times in the past.

The control on a form looks up a Customers Table and lists the CustomerID & Customer Nane, and displays them in the drop down box.
So far so good!!!

However, when I select a Customer, I get an Error Message "Cannot add record(s); join key of table 'TABLENAME' not in recordset"; but as far as I can see all relationships, field propeties, etc are correct. The field in the Customer table is 'ACNO' text, 8 chr, and in the 'OTHERTABLE' 'CustID' text, 8 chr.
(The form has a query as its recordsource)

The 'ACNO' is of the form 'ABC1234'.

Where is the error PLEASE??

[This message has been edited by EricH (edited 05-30-2001).]

[This message has been edited by EricH (edited 05-30-2001).]

Can you list:

Tables in the underlying query, with fields in each, and;

The query itself, and fields included?

The error suggests that the field necessary is in the table but not the query.

Matt