Group:  Microsoft Access ยป microsoft.public.access.formscoding
Thread: LinkChildFields, etc. (Access 2000)

Geek News

LinkChildFields, etc. (Access 2000)
"L.A. Lawyer" <kapplaw[ at ]linkline.com> 11/24/2008 10:12:31 PM
I want to programmatically change the child/master fields; the trick is that
sometimes I want to link on a single field and sometimes on TWO fields. How
is that done?


Re: LinkChildFields, etc. (Access 2000)
"Dirk Goldgar" <dg[ at ]NOdataSPAMgnostics.com.invalid> 11/24/2008 10:25:58 PM
"L.A. Lawyer" <kapplaw[ at ]linkline.com> wrote in message
news:O1ahxHoTJHA.5244[ at ]TK2MSFTNGP04.phx.gbl...
[Quoted Text]
>I want to programmatically change the child/master fields; the trick is
>that
> sometimes I want to link on a single field and sometimes on TWO fields.
> How
> is that done?


Specify both field names, separated by a semicolon. As I recall, though I
haven;'t done this recently, an error may be raised in when you change the
first property, telling you that you have an inconsistent number of fields
for link master/link child fields. This error can be ignored, as your next
line of code is going to change the other property to match.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net