I have a form with a combo box that is unbound. The form itself is bound to myTable The row source for the myCombo is a select statement based on the same, mytable.
When you select an item in the list, the form populates with the record using a macro on the after update event.
I was trying to write code for the not in list event that would advance the form to a new record and then place the NewData into the proper field as I have a bound text box to the same field that is the row source of the combo box.
This set up seems to be causing a problem. I'm using docmd.gotorecord to try and add a new record but it gives me an error: Run-Time error '2105'. You can't go to the specified record. I think it's because mycombo is unbound.
Should I try another way or can this actually be done? If it can, I'll keep working at it.
Thanks.