find record on the Many side

  • Thread starter Thread starter johnb
  • Start date Start date
J

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
 
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?
Click to expand...
How do you like to "find" it? Using VBA, a query or something else? Your
description is quite short.


mfG
--> stefan <--
 
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
 
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.
Click to expand...
E.g.:

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

mfG
--> stefan <--
 
Back
Top