By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,301 Members | 1,766 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,301 IT Pros & Developers. It's quick & easy.

Fetch values from form and update record in table

P: n/a
I haev a table "emp_details" with two fields ID,Name.
and created a form "record" with text boxs adn a command button.

I want to get the information from the user in these two text boxes and when the user clicks command the data needs to be updated in the table.

Please help me with how do i write query to insert the record fetching details from the form.
Oct 21 '10 #1
Share this Question
Share on Google+
1 Reply

P: 7
If all you want to do is move data entered by a person into a table, you can:
Create the table, with 2 fields (ID, Name). While thats highlighted, go to the create tab, click form.
It should come up automatically (If this is what you've done thats fine)

Add the command button, and use the command button wizard:
Under 'Categories' highlight 'Record Operations'.
Under 'Actions' highlight 'Add new record'
Click next, choose 'Text', Click next, choose the name of the button, then click finish.

You should then just be able to add a new record, click the command button, and then it should be entered into the table.

Is that all you wanted to do? Hopefully i understood what you wanted.
Oct 21 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.