I have a repeating subform that I am populating from a SQL table. There is a field in the subform that I populate as a dropdown based on values stored in another SQL table (Company) If the SQL record that populates the repeating subform has no value in the Company Number field (which is a valid scenario), the field shows "Please Select" (seems reasonable). However, when I update the SQL table with the repeating subform entries, the Company number column now shows "-1". Can I stop the form showing "Please Select" or at least stop the table being updated with "-1"?
Please sign in to leave a comment.