Please help with combo box!!!

I am trying to put together a database for work. This is my first database. I am working with two tables for now. One is basic client information. The other is records of the clients information about there different illnesses or injuries like date and details.

I have created a form to add new illnes or injury's to it. Within this form is a subform where I can add new date and details that updates the illness and injury table. As of now, I have to click the arrows at the bottom of the main form in order to find the client that I need to add an injury detail to.

What I want to do is add a combo box so that I can just click the drop down arrow and select the appropriate client and then it brings up that clients date and details boxes in the sub-form to add a new one. Also, can I have it where the previous date and details are not shown in the sub-form, just an empty box to enter a new one? Then I could just create a report to show a specific date range for a specific client?

Thank You Very Much for Your Help!!! I really do appreciate it. If I missed something that you need to know, let me know.

Chad

I don't mean to be negitive but it would take a book, albeit a small one, to answer all your questions. Even the best Access expert would take 1 to two days to complete the tasks you've outlined. Your best course of action is to purchase a good Access book and learn. This forum it truly great for getting you over the hump with a specific problem but not so good for answering the broad and general questions you have. A great site for articles and learning is http://www.mvps.org/access.

Good luck,
Marty

Sorry.....I figured that having a combobox do this would not involve so much. I'll give it another shot and see what happens, didn't work when I tried it before.

If I do not get it, how about having the records sort through in order by name instead of SSAN when I use the arrows at the bottom of the form? Sounds simple, hopefully it is,

Thanks,

Chad

Rather than use a Form/subform to enter the injury details use a form based on the injuries table. When you place the combo box on the form have it look up the personel table to fill the list and have the result placed in the appropriate field in the injuries table. I am assuming you have a single field primary key in the personel table which is linked to a field in the injuries table.