General information
Category:
Forms & Form designer
Title:
Combobox - Lookup and Edit
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only