insert into a table from a text field

[waymond]

I have a text field that displays the data from another pop up box form I need to insert that data once displayed into the table because after the form is closed it loses it value. The field is as400narr

 

[hkaing79]

You can use the SQL statement Insert.

CurrentDB.Execute "INSERT INTO table (as400narr) VALUES ('" & txtField & "')

 

[waymond]

where do I put the above code to make this work? thank You

 

[waymond]

where does this code reside in the afterupdate or where?

thank You

 

[waymond]

Im trying the following code:

CurrentDb.Execute "INSERT INTO OBJECT(as400narr) VALUES [Forms]! [objQry1] ! [text35]"

is this possible now I am getting syntax errors
Please Help

 

[hkaing79]

I would use a command button and the On_Click() event.

CurrentDb.Execute "INSERT INTO OBJECT(as400narr) VALUES ('" & [Forms]![objQry1]![text35] & "')

 

[waymond]

still does not work does not update the table with the value

 

[hkaing79]

Any error messages? It should update your table.