find record on the Many side

[johnb]

Hi Guys,
I have a Form with a 1 to many relationship between 2 tables with ref.
integrity enforced. I need to find records stored on the many sided table.
Anyone point me to KB or other tutorial that doe this?

TIA
johnb

 

[Stefan Hoffmann]

hi John,

I have a Form with a 1 to many relationship between 2 tables with ref.
integrity enforced. I need to find records stored on the many sided table.
Anyone point me to KB or other tutorial that doe this?

How do you like to "find" it? Using VBA, a query or something else? Your
description is quite short.


mfG
--> stefan <--

 

[johnb]

Hi Stefan
Thank you for the reply.

I need to have command button some where on the form/subform display so that
a user can locate a record. For example: click a button a modal form pops
up, type in say "Smit" for the last Smith. A results form displays all name
with last names starting with "Smit". Double click on the one you want and
that is now displayed on the original Form/Subform. I hope that clear.

regards
johnb

 

[Stefan Hoffmann]

hi John,

I need to have command button some where on the form/subform display so that
a user can locate a record. For example: click a button a modal form pops
up, type in say "Smit" for the last Smith. A results form displays all name
with last names starting with "Smit". Double click on the one you want and
that is now displayed on the original Form/Subform. I hope that clear.

E.g.:

http://support.microsoft.com/kb/304302
http://allenbrowne.com/ser-62.html

mfG
--> stefan <--