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

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

"aft3rgl0w" <(E-Mail Removed)> wrote in message
news:79ACB4F0-4A1B-4592-A24E-(E-Mail Removed)...
> 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!!

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

"Alex Dybenko" wrote:

> 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
>
> "aft3rgl0w" <(E-Mail Removed)> wrote in message
> news:79ACB4F0-4A1B-4592-A24E-(E-Mail Removed)...
> > 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!!
>
> .
>