MS Access - Form Question

[tntcoder]

Hi,

I have created a form, that has several combo boxes, edit controls e.t.c their data is collected from various tables and the user is able to edit them.

What i need to do is make several buttons, that can add, create, save, delete... records. However the form isnt linked to a table? Im not sure how to do this, i have a table specially created for the data that the user selects in the form to be saved to.

So basically I need to know how to link the form to a table, and make the buttons add, save, update... the records in that table.

I have tried the build wizard that comes up when you create a button, and selected the record operations, but they dont seem to do anything because the form isnt tied to a table?

Any ideas? (probably something really simple )

Thanks
Jack

 

[TrUz]

Is this a project for personal use or is it something you have been assigned and it has to be in access? If it is just for you then I would suggest getting a copy of VB.NET and SQL Server Express or even just use the Access database witout using the forms within access etc...

But, for adding records through access you can either bind you textboxes and comboboxes or you can leave them unbound and use DoCmd.ExecuteSQL I think. This was you can use your normal INSERT, UPDATE etc...

TrUz