>>Have a view with 3 fields. Have a form with 3 controls (combobox, editbox, character). Combobox rowsource is an array (result of SQL-Select into an array in form load method).
>>1. User should be able to pick record from the combo and the corresponding other 2 fields refresh.
>>2. User should be able to add an entry to the combobox and the other 2 corresponding fields would be blank. User could then update them as well.
>>3. When all is done, I fire a tableupdate() and get all the info into the original table.
>>I got my lookup array populated, but even this simple valid() in the combobox not working:
>>locate for messagesupdate.cMessageID = ThisForm.Combo1.Value
>>ThisForm.Refresh
>
>When oyu say the other two fields should be refreshed, do you mean that they they should be populated after the choice is made, with values from other columns in the array?
>
>When the user adds an entry to the combo, should it be saved so it will be available to choose from next time?

What I am targeting is user clicks from the combobox dropdown (array recordsource) and the value is used to locate a record and the other two controls are refreshed with my view's values after the choice is made from the combobox. If the user adds an entry, then the other two controls will be blank and the value they added gets inserted into my view.