OK, Tom,
So you are trying to show existing records in a combobox for a table that you also want to be able to add records to? Hmmm. This sounds awkward. Generally, a combobox is used to list values from
other tables. Have you considered using a list or grid to show existing records?
>You'll have to excuse my lack of terminology- I'm quite the novice.
>
>>Need some clarification here....Are they combo or list style? What is the >controlsource? What is the rowsource? What is "data1"?
>
>>data1 = thisform.mycombo.value
>
>These combo boxes are list in nature and the data source is the same table that I'm trying to add new records to.
>
>The row source is something I'm not quite up on...any description you can give will help.
>
>Data1 is a sample variable name that I was using to reference the value typed into the combo box.
>I may be doing this all completely incorrectly. Simply put- my users need to be able to input info into a form and the form needs to input that data into a table.
>Thanks-
>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