I've got a challenge for you!

[HowardChr]

Here's a tricky little problem I am trying to figure out. I'm sure someone out there should be able to help me without breaking anything. Heres the problem.... I have a form that has an underlying table attached. I have a combo box pull in a pull down list of locations from that table. What I would like to happen is, I would like it so the user will select a location from that combo box, and then click a command button. When they click that button, I need whatever they chose in the comobo box to copy over to a NEW table, which will be referenced later by my program. Say the table being pulled from is called "table1", and the table I need the info to go to is "newtable". I guess it doesn't SOUND hard, but I can't seem to figure anything out on it. I'll let you experts tear it apart and tell me how dumb I am for not knowing. Be kind... I'm still a noob.

 

[neileg]

You don't need a new table, you need a query that uses the value from the combo box as a criterion.

 

[GaryPanic]

Neil - has stated the this correctly
unless you go in to more detail as to why you would want to do this - this is the way to go ...

 

[HowardChr]

You don't need a new table, you need a query that uses the value from the combo box as a criterion.

OK.... I haven't used queries too much.. how would I do that?

 

[HowardChr]

Neil - has stated the this correctly
unless you go in to more detail as to why you would want to do this - this is the way to go ...

I am essentially creating a program that starts by someone setting up locations to do a walk around a store. When they type in which location they are at , it will give them the list of locations so they can choose the corresponding location to that number. After this is set up, they wouldn't need to set it up again. Each store is different though, which is why I have to do that.

 

[GaryPanic]

THe wizard will show you how

take your time using the wizards - do it slowly

what you need to begin with is a field on your table that will store this info in
fieldA (no numbers or spaces)
now when you use the wizard there are a couple of tips
make a qry on your location table start this with the name of the location (otherwise you are into Dlookup- no my area I kinda lose the plot on this)
so you table will look like this
id 1
name fish lane
make your qry look at the name first so
name fish lane
id 1

now when you use the wizard make it look at the qry instead of the table ( this is the general rule for combos)

now the wizard will ask what field to appear and what field do you wish it to store in- you should be able to figure the rest out on this ...
g

 

[HowardChr]

THe wizard will show you how

take your time using the wizards - do it slowly

what you need to begin with is a field on your table that will store this info in
fieldA (no numbers or spaces)
now when you use the wizard there are a couple of tips
make a qry on your location table start this with the name of the location (otherwise you are into Dlookup- no my area I kinda lose the plot on this)
so you table will look like this
id 1
name fish lane
make your qry look at the name first so
name fish lane
id 1

now when you use the wizard make it look at the qry instead of the table ( this is the general rule for combos)

now the wizard will ask what field to appear and what field do you wish it to store in- you should be able to figure the rest out on this ...
g

I only had a few options when going threw the wizard before it made me click finish. Where are all the other options you have listed? Someone also said something about useing the after update function of the combo box itself. Any ideas here?