How to make subform link with main form in Microsoft Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HELP!

I read the other entries, but they don't make much sense to me. I don't
know VBA, but I can copy a formula. Anyway I have a subform which won't
link to my main form. I only need 5 fields to link to the main form, but
it's not happening. I don't think my relationships are working either. And
when I try to link or import from Excel to Access, my tables don't link
either. I'm cofused and frustrated.
 
Please tell us more about your form and subform, and their respective record
sources.
 
Well the main form get's info from a spreasheets I imported from Excel. I
now have a "Main Table" that I use for the main form. The subform only is
supposed to use 5 fields from the main table or main form. The rest of the
fields on the subform will come from the subform table whose information has
not been fully input at this time. What else do you need to know? Not sure
If I answered your question.
 
I'm not sure if I'm understanding correctly, but it sounds as if the
subform's data are related to the main form's data through the combination
of five fields in the main form's recordsource? If this is correct, open the
main form in design view, click on the top edge of the subform control, then
click on the Properties icon on the toolbar, and then click on the Data tab.

There you'll see two boxes: LinkChildFields and LinkMasterFields. You list
the field names in those boxes (separated by semicolons) in the same order
for both (Child refers to the field names in the subform's recordsource,
Master refers to the field names in the main form's recordsource).

If this is not what you're seeking to do, then you'll need to describe the
tables and data that you're using for the main form and the subform -- field
names, data types, how the tables are related, etc.
--

Ken Snell
<MS ACCESS MVP>
 
Ken Snell,

YOU ARE THE S**T! Thank you so much for your help. Your suggestion was
what I needed to pull it off! Everything is working as it should.

Peace & chocolate,
eleganthippy2005
 
can u help me too. I too have the same problem. but as you said i am unable
to find the LinkChildFields and LinkMasterFields in properties window.

What i need is using Select queries and filters, retrieve a subset of Access
records from a table to the the subform.

please help
 
Back
Top