General information
Category:
Forms & Form designer
VFP5.0a (still waiting for our 6.0 order to arrive)
I have an employee table that contains the usual information such as name, ssn, company, etc.
When the user adds a new employee, I need a combo box that will list the existing companies with incremental search capabilities, and at the same time allow entry of a new company.
I found code in the 1996 DEVCON session by Tamar, "combo boxes, the forgotten controls". It gave me 99.9% of what I wanted, but I'm still missing something.
I use a SQL statement to populate the row source:
"Select distinct company from employee"
Row type of course, is SQL statement.
When I click on the form's Add button to add a record, I am able to type in the new company into the combobox, but it "disappears" when I do a requery(). If I type in the new company and force a tableupdate, then the requery works fine, but the Revert button has lost all meaning.
I'm sure someone has already figured this out.
Thanks in advance
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