Subform to coincide with master form?

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

Guest

I have a master form with general info on it and I want to call up a subform
that matches the current record but has more specific info. For example, my
master shows the name and address of a marina, I then want to call up a
subform that I can input and view the historical slip rental rates for that
facility. I have both forms made already but can't seem to get the subform
to coincide with the master.

Thanks.
 
I am assuming you are using an Autonumber field, MarinaID in
your Marinas table with corresponding long intger MarinaID
in your related table

on your Slips subform, put a textbox

Name --> MarinaID
controlSource --> MarinaID (in related table)
Visible --> No

on the main form
Name --> MarinaID
controlSource --> MarinaID (in Marinas)

for the subform control

LinkMasterFields --> MarinaID
LinkChildFields --> MarinaID



Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 
Back
Top