Inserting data through forms

[nivi30]

Hi,
I have a set of tables. I want to update these tables through a user interface.

Hence I have created a form for this purpose. Now how to i insert the values the user fills in the form to the tables. I have been looking at creating queries however I seem lost.



Kindly let me know.

[Ahmed Elalfy]

You can use append query to append entered data and after that delete query to clear data entry table.
create macro to run the 2 queries (append is the first)
insert the macro in form close event.