>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?
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?
Erik Moore
Clientelligence