Linking a subform to current record
in [Getting Started]
|
Prev: Group Control Missing
Next: Font Color in Technic
From: KenSheridan via AccessMonster.com on 5 May 2010 08:46 What is the ControlSource property of the Drawing Number control in the subform? Ken Sheridan Stafford, England bezzauk wrote: >Thank you, > >I have managed to find and do the below. But now the Drawing Number field in >the revision subform displays #Name? >Which makes me think it cant find what it is looking for!! > >Confused!! > >Cheers > >>Bez: >> >[quoted text clipped - 13 lines] >>>>subform is based on) then goto Properties - Data and set the Link Child >>>>Fields and Link Master Fields to the matching fields. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/201005/1
From: bezzauk via AccessMonster.com on 6 May 2010 06:39
Thank you, I think its working now. Your prompted me to look at the control source property for the subform. This was pointing to the revision details form, rather than the revision details table. I changed it to the table and it now appears to work ok. Many thanks KenSheridan wrote: >What is the ControlSource property of the Drawing Number control in the >subform? > >Ken Sheridan >Stafford, England > >>Thank you, >> >[quoted text clipped - 11 lines] >>>>>subform is based on) then goto Properties - Data and set the Link Child >>>>>Fields and Link Master Fields to the matching fields. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/201005/1 |