Lookup record in subform based on combo im main form

  • Thread starter Thread starter SAC
  • Start date Start date
If the FacilitiesLookup field in tblEvents really is a
Lookup Field, then No, you should not do that.

I need an explanation of the difference between the ID field
and this FacilitiesLookup field. From where I sit, it seems
like they have the same value (the foreign key to the
Facilities table). Check tblEvents to make sure that the
FacilitiesLookup field has its Lookup - Display Control set
to Textbox. Then see what's in these two fields and note
any records where they are different.

Have you verified that the BoundColumn property of
cboFacilitiesLookup really corresponds to the ID field?

Have you tried setting the Link Master propeprty to
cboFacilitiesLookup? If you did, did is make a difference?
 
Marshall, I think I'm going to have to let this one work without doing the
Master/Child Link. I'd like to know how to do that, but I guess for now
I'll have to learn that later.

Thank you so much for your help....you did get it to work for me and I
really do appreciate that!!

Thanks again!
Marshall Barton said:
If the FacilitiesLookup field in tblEvents really is a
Lookup Field, then No, you should not do that.

I need an explanation of the difference between the ID field
and this FacilitiesLookup field. From where I sit, it seems
like they have the same value (the foreign key to the
Facilities table). Check tblEvents to make sure that the
FacilitiesLookup field has its Lookup - Display Control set
to Textbox. Then see what's in these two fields and note
any records where they are different.

Have you verified that the BoundColumn property of
cboFacilitiesLookup really corresponds to the ID field?

Have you tried setting the Link Master propeprty to
cboFacilitiesLookup? If you did, did is make a difference?
--
Marsh
MVP [MS Access]

Yes. The FacilitiesLookup field is in the main form's table.

Sorry for the confusion.

So I would like a Link Master/Child

Master - FacilitiesLookup
Child - ID

Is this clearer?

I know it's an odd structure. Should I not do this?
Click to expand...
Click to expand...
 
SAC said:
Marshall, I think I'm going to have to let this one work without doing the
Master/Child Link. I'd like to know how to do that, but I guess for now
I'll have to learn that later.

Thank you so much for your help....you did get it to work for me and I
really do appreciate that!!
Click to expand...


Good luck with you project.
 
Back
Top