Current field must match the join key??????

[gdonald20]

Hi

I have a table called Enquiries and a table called Viewing_Appointments.
These tables have a one-many relationship on the field called EN_Id.

On my form i have a combo box which filter out the enquiries relating to the
specific person record that you are on. When you select the enquiry in the
combo box it gives you the correct options for the person but once you have
picked an entry it gives you the error "current field must match the join
key" blah blah blah.

I really don't understand this error because for example if you are picking
enquiry 13 and trying to store that number in the field VA_EN_Id the
corresponding enquiry id does already exist in the table enquiries so
therefore the one side is filled in.

Please any help would be appreciated, think i'm too close to the problem to
see the solution.

Thanks in advance.

Gillian

 

[Rod]

Gillian,

What is the recordsource of the form and how does the combobox filter out
the enquiries? (Is the combobox value part of the form's recordsource or do
you change the recordsource based on the combobox value?)

What do you mean by "once you have picked an entry"? Is this in the
combobox or do you have a list on the form related to a successful filtering
by the combobox and you then select an entry from the list?

You mention "trying to store that number in the field VA_EN_Id". If you are
using this field to match records in the tables (the join key) why are you
trying to change it in the set of matched records?

If these questions make sense let me know (and the answers) and we may be
able to sort out the problem.

Rod.