Combo box in a form. HELP!

[jwright]

So im very new to Access and trying to wrap my head around it...but access is winning. i remember taking VB courses 6 years ago but i havnt used it since and its foggy in my memory.

Basically i have Form that i want to pull specific data from a single table when i select from a drop down box, so im guessing that onchange would be used and a bunch of if statements??


here is a sample(not the actual table) but close to what it will look like.

this is what it looks like...i would like it to pull information from my table once something has been selected from the combo box

so for example-
combo box = surgical specialists then i would need it "find"the practice manager of surgical specialists and place it in the Practice manager field
same with the phone number, fax, ect...
any help is appreciated!!

[June7]

Knowing VB doesn't necessarily prepare for understanding relational database.

What do you want to do with the 'pulled' data? Should NOT be saving it into another table - that is duplication of data.

If you only want to display the related info, there are several ways to accomplish.

1. set the combobox as multi-column - the additional columns for the related info, then textboxes can refer to the columns to display
column index begins with 0 so if address is in column 2, the expression would be like:
=[comboboxname].[Column](3)

2. include the Name in form RecordSource by join to table that is the primary data for the form, join type 'Include all records from {primary table} ...'
bind textboxes to the related data fields and set them as Locked Yes, TabStop No

3. DLookup() function

Also, review http://www.datapigtechnologies.com/f...tomfilter.html

[orange]

Do you have a good description of your Business and the business rules? Do you have a data model?
Does the model support the Business? Have you tested your model against your Business rules?

Getting your structures - tables and relationships - set up properly is critical to database success.
Forms and interfaces are important, but in my view, come after tables and relationships.

Here is a tutorial to put all this into context. Good luck.

[jwright]

i did some coding this morning and this worked. afterupdate pulls info from my table based on the value and fills in the text boxes, but i dont think it is very efficient. Currently seeing if i can do the same for the employees to be added into a text box that are associated with the ComboBox. like i said im new to it and will be taking the advice above ^ thanks!

[June7]

I think code in this case is like driving an Indy 500 car to the grocery store.

I gave you 3 options that did not involve VBA code.