Ok, I added 2 combo boxes to a form. After the change when I would try to save a record, I would get an error saying "You cannot use a null value for a field that is not a variant data type". I tried to fix it and was unable to. I used a workaround where I added a value to each combobox/table saying "Select..." so the boxes are filled and I can save without the error.
A new problem has come up. When I select a specific record from the main form, it doesn't select the record and instead a new record/form pops up (It should open up the record in the form with the new combo boxes). I ran the debugger and the code is not getting the id from the main form. It used to. WTF? I didn't touch the main form. I can't figure out why it no longer works. Please help. Please.![]()
thanks!