access 2007 dynamic creating child and master link fields on subfo

[aft3rgl0w]

I have a form used for searching, and a subform displaying by default a
datasheet of the table being searched. there is a listbox above that
displays the results as the user types. with a click of a button, those
results can be mirrored to the subform (recordsource is changed through vba).
this works fine i naccess 2003. in access 2007, after the update, access
seems to be automatically creating master and child link fields on the
subform between itself and the main form. it is doing this on it's own on 5
forms set up the same way but for searching different tables. any ideas on
why it's doing this by itself? it causes the datasheet to come up emtpy.
thanks in advance!!

 

[Alex Dybenko]

Hi,
try to clear them in code after you changed recordsource:

Me.MySubform.LinkChildFields = ""
Me.MySubform.LinkMasterFields = ""


--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[asouthy]

I have been having the same problem on many of my databases and haven't
previously been able to locate a solution. Thank you, this worked perfectly!!