data capture form/make table query

[nianko]

Hi Forum,

I'm sure you will think that I could find the answer to my pb in FAQs. I might be stupid but I can't (btw, if you have an interesting link I'd love to read it).
Well, I just 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 data in the query and then update the table?

Do I have to use code for that, like RecordSet, or can I just work with the wizard?

Thanks in advance if you can help.

nianko

 

[ghudson]

It would be easiest if you bound your form to your table. That way any changes to the current record in the form will be saved to record in the table when your form is bound to your table.

 

[nianko]

Hi,

Yes that's what I did first, but the user can access the former items in the table. And I want him/her just to add data, not review them...