create a form that will update an existing table or add a new record

[gray78]

I am having trouble creating a form that will be able to update an existing table as well as add new records. The form has a combo box(tag#), but if I want to add a new tag#, I cannot do this. The combo box allows me to see existing tag#'s and the data associated to them.

Any suggestions?

Thanks

 

[gol4]

Did you try edit-goto-new record

 

[lamarw]

Given:
The control has access to the entire column of data in the table.

Then:
Test the [controlname].ListIndex when you are ready to add the item. If [controlname].ListIndex = -1 then the entry is not in the controls list(which should represent the entire list of entries in the underlying table). If that's the case then add the item to the table then requery the control.