Join Key Error

[Guest]

I am trying to base a form on a Query that contains data from a main table
and a look up table. When I try to update the information in the form I am
getting a Join Key error on the recordset and it will not allow me to add
records.

Any suggestions?

 

[Guest]

Hi ksfireworksgal,

Usually a join error will be related to trying to either
(a) add something that doesn't exist in your linked table
or
(b) not selecting something when it's required to be selected (by the linked
table).

Check that you aren't attempting to add a value that isn't in your linked
table. Also check that you don't have numeric fields (used for linking) that
default to 0, as this will cause the above error also.

Can you run your query and have it return results correctly?

Damian.