Combo Box question
Posted on 2012-09-06
Have a problem with a combo box, which I assume I am not setting up correctly.
For the first time I have a combo box which can either have no selection or a selection not currently in a table. I want to be able to enter text, and if the box cannot find a match just save the value in the current table.
However, the table is setup to allow lookups from other table and select them, if desired. I name the Rowsource table (Payers) and the RowSourceType set to 6-fields.
The problem is that every time I hand enter a value that does not exist in the table, NO value is saved in the Checks table. If I use a code known Payers, no problem. A check in the VALID method shows the hand entered data is not said if no reference in Payers.
Anyone have an idea how to save the data in the one table if it does not exist in the other. I plan to give the OPTION to save the data if the customer desires.