Hi Tom,
Need some clarification here....Are they combo or list style? What is the controlsource? What is the rowsource? What is "data1"?
>Hey everyone! I'm having some difficulty with combo boxes.
>
>For example: I have ten combo boxes which correspond with 10 database fields. The user needs to enter new info to be added to the database and then be able to repeat the process infinately. I've tried referencing the value of the combo box like so:
>
>data1 = thisform.mycombo.value
>
>In the builder I tell him under value to enter the data into the corresponding field. I have command button that under many attempts of appending and yada yada. Nothing seems to work. I'm sure I'm letting my nearsightedness get the best of me. But sue me- I'm stumped! Help!?!
>
>Tom Welch
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05