update a form with user's imput

[nianko]

Hi Forum,

I need to create a form that will allow my user to capture data that will come to update my table ("tblINTERESTS"). Instinctively i create a make-table query that I would like to update the table.
I also have a form ("frmUserAddNewInterest") where all my fields are unbound. How can I tell my form, to send the user's input in the query and then update the table?

Thanks in advance if you can help. The question is quite straighforward, if you have the answer on another link I'd like to read that.



nianko

[weekend00]

Don't use "a make-table query" to update a table.

The easiest way is to link the form to the table, anything the user input to the form will save to the table, you don't need any code or query to update the table.

[nianko]

Hi,

Thanks for your answer.
The thing is, I want the user to open a form, enter the data (i.e. a new interest), click on a command button "ok" so that it validates the data entry.
I don't want the user to be able to see the previous records in my table (which you can do by scrolling). Also, I don't want the data to be entered in the table if my user doesn't click on the command button.

So far I am the only person working on the data base and adding new input. I try to make it ergonomic, so that my team can use it too (sithout using the integrity of the DB of course).

How should I do then?

Thx

[weekend00]

All right, I think what you want to know is how to run an update query in VBA code.

see the example:

private sub command0_click
currentdb.execute "update theTable set field1 ='"+ textbox1 +"' where condition"
end sub

It's a simple one, hope you can understand and change it to fit your needs.