Lookup record in subform based on combo im main form

M

Marshall Barton

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?
 
S

SAC

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?
 
M

Marshall Barton

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!!


Good luck with you project.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top