Link table on form

[Saylindara]

I'm sorry if it seems I'm bombarding you with questions but I've worked
solidly for 3 days on this database and won't have another chance for a week
or more.
I thought I had this sussed but found out I didn't.
I have a main form Event and a subform based on a link table
EventJobTitleStatus with comboboxes for JobTitle and Status based on tables
of the same name and they work fine.
It transpires though that the EventID field on the link table is not working
as it remains stubbornly blank no matter what I do (I need it to have the
same EventID as on the main form). I have other linking tables on other forms
and they're all right, why not this one?

 

[Cheese_whiz]

Hi Saylindara,

Check the link master/link child properties in the subform control (not the
form in the subform control, but the subform control itself).

HTH,
CW

 

[John W. Vinson]

I'm sorry if it seems I'm bombarding you with questions but I've worked
solidly for 3 days on this database and won't have another chance for a week
or more.
I thought I had this sussed but found out I didn't.
I have a main form Event and a subform based on a link table
EventJobTitleStatus with comboboxes for JobTitle and Status based on tables
of the same name and they work fine.
It transpires though that the EventID field on the link table is not working
as it remains stubbornly blank no matter what I do (I need it to have the
same EventID as on the main form). I have other linking tables on other forms
and they're all right, why not this one?

Please post the Recordsource SQL of your mainform and child form, the
fieldnames and datatypes of the relevant fields, and the actual Master and
Child Link Field properties of the subform control. Are any of these fields
Lookup Fields? If so that may be the problem...

 

[Saylindara]

Thank you very much and to Cheese_whiz.
While finding the information you asked for I spotted the problem myself -
the wrong masterfield on the subform control as Cheese_whiz suggested.
I'm very grateful to you both.

 

[Saylindara]

That revealed the problem. I'm very grateful.

Hi Saylindara,

Check the link master/link child properties in the subform control (not the
form in the subform control, but the subform control itself).

HTH,
CW