Fetch values from form and update record in table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Guru S

    Fetch values from form and update record in table

    I haev a table "emp_detail s" 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.
    tahnks!
  • Rixxe
    New Member
    • Oct 2010
    • 7

    #2
    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.

    Comment

    Working...