Query Based on User Input in a txt box 1

[DDWatkins]

Ok I have a form which the user enters a first name and a last name. ( along with much more data) this data becomes know as the client info. After all data is entered, we assign a number, Not an auto number because we give each client a number based on the name Ex say we have a john doe and we have already done like 10 things for him his numbers may look like this 100.01, 100.02, 100.03, etc. ok
Now on my form i have a tabs along the top of my form which shows related info. On one of these tabs, i have subquery which i want once the user enters a first and last name , i want it to list only the that clients records. How do i do this?
I will want it set up to where the query will update each time a first and last name is entered. Can any one help me ? I am a newbie and not really familar with code so any help will be greatly appreciated.
Thanks
Dywayne

 

[TranPlan]

DDWatkins -
If your data is "one to one" - ie you don't have multiple records relating back to your Client, then you don't need the subform.

If you plan on having an infinite (so to speak) number of associated records, I would put the client's vital information in one table, and all associated infinite data, in another table, making up a "one to many" relationship - for example:

Member: John Doe
Committees: XYZ,ABC,123,789,etc.

the member's name and vitals table should be reflected on the main form, and the "infinite" table info should be reflected in the subform -

Use a the combo/list box wizard to help you create a "Last Name" control on your main form that advances to the "infinite" data for the particular client you choose - Simply have a place to enter the client's name, and all the information, and then a list or combo box that you can refer to with all your current client's last names listed - when you select the last name of a various client, all their information will show up -

I do this sort of setup on most the dbases I set up, and it works really well -

Hope this helps -

TranPlan (Jon)

 

[DDWatkins]

Thanks for the reply,
Now i Have done this that you have told me to do now here is my next question. Now that I have a combo box set up to select the last name from the drop down list, how do i get it to show all the other client data in the text fields based on the selection in the combo>?

thanks so much.. I am really getting close to being done... so any help and all help is needed