Automatically Populating Form after selection

[NLugo]

Hope someone can help...

I have one table which has emp #, Address, City, State and zip. What I would like to do is create a form that will have a list box. I will then select the emp# and all the other data pertaining to that emp# will automatically populate on my form. How do I do this? and...how can I create a generic letter in access that I can mail to the employees that I have selected?

Thank you in advance for your help.

 

[Vav]

Are you still needing a solution to this problem? It is very simply... Let me know if you would still like the solution.

 

[NLugo]

Yes please.

Thank you in advance.

 

[sandhurstUK]

Hi guys,

I would also be interested to know how to achieve this.

Thanks
Ian

 

[ggreg]

your form can have a list box to pick the emp # which in
turns set the criteria in a query, the query should have all
the fields you need in your letter, base a report on the query and
make the report your generic letter... now the form that
you pick the emp # place a button that you press to preview the
report.....in the query... of the emp # in the criteria place
[forms]![nameoftheform]![emp#nameoffieldorlistboxinform]

does this help you two?

Greg

 

[NLugo]

Thanks Greg!! I'll definitely try this.

 

[Rob.Mills]

Another thing you can try is setting up an auto-lookup query. That might be what Greg was describing. Anyway, the help menu gives good instructions on using these.

 

[lois chipperfie]

Hi! I would suggest that you to the following site and do the combobox example--it does exactly what you want to do and once you see how that works, you can adapt it to your problem. Good Luck! It worked for me www.ageesw.com/access.htm