Discussion Locked

Access 97 Open Data Form w/Selected Rec

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

5 replies

by donq

Base "Data Entry" on a query where the "fullName" has the following entry in its "Criteria"

[Forms]![Selector].[List8]

Open Selector BEFORE closing Selector.

This discussion is closed to new replies.