Hello,
This is my first post and I am relatively new to VBA but not to programming in general.I have a small table that I successfully created a small search function for and now I am trying to find a way to add records to the table.
As of right now I have a main form with 2 buttons, one for the search and one for the add. The form for the add is finished except for the VBA in the back end. The fields in the add form correspond to the fields in the table but I can't figure out how to go about getting new records into the table. Is it an SQL INSERT statement? Or is there a built in function in VBA that will allow me to do this?
I was hoping to get some insight on this as well as maybe an example. Anything else I can do to clarify my problem, code, screens etc. let me know I would be glad to post. Thank you ahead of time.