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
