some access basics

hey guys,

i'm an asp + access programmer but i wanna start doing stuff for windows aswell
so i'm trying to get to the bottom of access abit more and there a few things that arent
clear to me:

1 - i have a form with a username field that displayes all the users in a certain table.
so i have one box benith another box.. and so on.. thats all fine and well.. now i've created
an "update" button that calls an update query that is suppose to update the table according to the changes
made to all of the username fields. but it doesnt really work.
after i click the button it opens a dialog asking me to manually input the value for the form field i defined in the query
instead of reading it streight from the form?!.. could someone take me step by step of how to build the update query?

2 - using the same form i created a seperate username field with a different name and i wish to insert it's content as a new
row to the table when i click a different button. how do i build the insert into query?


3 - is it possible to run those 2 queries togather using one button? lets say first the update and then the insert?

thanks very much!

The message box is indicating that it can't find the control name on your form and is treating it as a parameter. Make sure that you are using the control name of the control on your form and not the field name from the table. You can run both queries from one button using VBA. The easiest way is to construct your queries to perform the task that you are wanting them to do and then behind the button you would use the DoCmd.OpenQuery methods.
lwells