Need some help...combo box selection, then fill other fields

[smann]

I have been trying for a few days to make this work and I can't figure it out. I'm sure it is probably something real simple.

I want to be able to select a value from a combo box and then have the other 3 fields fill in based on the value I selected in the combo box.

I have looked at the Tradewinds sample db in Access, but I can't figure out what they did. Look at the the ORDERS form and then see how the 'shipping information' fills in after the customer ID is selected. That is what I want to happen with mine.

I have tried several different things. I can get one field to do it, but the others won't.

I can send you the db if you want to look at it.

Any help is appreciated.

Thanks.
Steve

 

[mhartman]

Here you go.....
http://support.microsoft.com/kb/304463/en-us

Regards
Mark

 

[darrrellx]

Question for Smann

Have you gotten your lookup to work. I am trying to do the same thing but it is not working. Any help would be appreciated.

Thanks

Darrellx

 

[smann]

thanks, I'll give it a try!

 

[smann]

I don't think that is exactly what I am looking for. It only gives one value in the field. I want to be able to pull down, click on one item and have it fill in values on my form for 3 other items.

 

[neileg]

You need to have all the fields you want to use as columns in the combo box, although you can set the column width to 0 so it doesn't show. Then use the Column() property of the combo to populate your other text boxes, eg
Me!cboMyCombo.Column(3)
as the data source for the text box.

 

[smann]

this is what it is tellling me. What didn't I do correctly? It is giving me the #NAME? error in the text field.

 

[neileg]

#NAME usually means you've got the syntax or the spelling wrong. Can you strip out and compact your database and post it here?

 

[smann]

I'll see what I can do. I think maybe I have my record source set improperly. Would that be the source of my troubles?

 

[smann]

See if you can open this.

when the welcome screen comes up, go to ADD/EDIT TOOLING-PART. Sorry.

 

[smann]

I think I figured it out I'll let you know. I think it was the record source.
Thanks for the help.

This is what I found and did....

http://support.microsoft.com/kb/319482/en-us

It was the record source setting. I created a new table according to the directions on the kb in the link. Then I rebuilt my form setting the combo boxes in VB following the pattern it shows in the directions.

I'll post a sample when I am finished.

Whew. That was kicking my rear for the longest time!

Thanks for the help. The posts here really lead me in the right direction!

 

[smann]

Here's what I came up with.