Idea -

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

Help?