>>>How do add new record to a combo box??? I want to key new records into a combo box.....The developers guide is using a This.AddItem(This.text), in the valid event of the combo box. I cannot get this to work.What else do I need to change??
>>>
>>>
>>>Holly Clawson
>>
>>
>>What is your rowsourcetype? If it's not 0, the additem methods don't apply. If you need an option other than what's indicatied by your rowsource, put it in an array and may the array your rowsource.
>>
>>HTH
>
>My rowsourcetype is 6 for fields. Are you telling I cannot add unless it is zero. That is what I am getting out from help. Is there a work around for this using fields as the rowsourcetype.?
>
>Thank you
>
>HOlly Clawson
Before the combo init (form.load) use something like this:
SELECT {field} FROM {table} INTO ARRAY {THISFORM.aRowSource}
rowcount = ALEN('THISFORM.aRowSource')
DIMENSION THISFORM.aRowSource(rowcount+1)
THISFORM.aRowSource(rowcount+1) = "New Value"
that's the general idea..
HTH
Matt McDonnell
...building a better mousetrap with moldy cheese...