How to use a form to insert data in a table?

[talhamoin]

I have created a form. I want to add a button so that if the button is clicked the values in the fields of form insert into a table of my database. Can someone help?

My database name is database and table name is purchase_invoice.

 

[MajP]

Is there a reason for not using a bound form?

 

[talhamoin]

Well, yes. I have placed two dropdowns in the form viz. Item Name and Customer Name. These drop downs are getting values from other tables i.e items and customers respectively.

Form has these fields:
Invoice no.
Invoice Date
Item Name
Quantity
Rate
Customer

Item name and customer fields are dropdowns as mentioned earlier. Rest of the fields are filled by the person entering data. I want to put OK and Cancel button on the form.

 

[MajP]

None of those reasons really justify the need for an unbound form. That can all be done with a traditional bound form. I do not have issue with using an unbound form, but that is usually for people who have knowledge of coding and database design. Since, you have no idea where to start I assume you are a novice, and would recommend you use a bound form. If you are more advance than show the code and insert query you have so far and we can help with that.