Add new record to a table.

[calvinle]

Hi,

I currently have 2 table "tblContract" and "tblFund" and in frmEdit, I have 2 button, which I want that after you write a teacher name in the combobox, if it's not in the request, the user will be able to add that new record. Also, if they will able to delete that record too.

The main record in the combobox is: "Teacher ID".

Please help.

 

[ranman256]

If the combobox is pulling IDs then you wont be able to add new record because it uses IDs not Teacher names.
Youd have to build an ADD button, open the form to add record, and a save button to 1. save the rec, and 2, update the combo with new recs.