Access 97 Open Data Form w/Selected Rec - TechRepublic
General discussion
August 24, 2001 at 01:35 AM
mra2

Access 97 Open Data Form w/Selected Rec

by mra2 . Updated 24 years, 10 months ago

I have a Form called Selector.
It has an unbound list box called List8.
The Row source is:
SELECT DISTINCTROW [LetterSelector].[fullname], [LetterSelector].[Mem_ss],[LetterSelector].[m_shop_id1], [LetterSelector].[m_status] FROM [LetterSelector];

When I click on any name in Selector I want to open a Form called Data Entry and see the information for the record I clicked in selector.
I also want to close selector.

I can get Data Entry to open but it ALWAYS shows the first record in thedatabase no matter what I do…..

THANKS FOR YOUR HELP!!!!
mra2@mindspring.com

This discussion is locked

All Comments