Hi,
I have a table called PLUs, I need to update the value of the field called Desc from an unbound field on a form.
I am trying the following line of code and cannot see what is wrong with it, please can you help?
<DoCmd.RunSQL "UPDATE PLUs SET Desc = Forms.EPOSControl.Starter1Description WHERE Code = '1118'">
or
<DoCmd.RunSQL "UPDATE PLUs SET Desc = Forms.EPOSControl.Starter1Description WHERE Code = Forms.EPOSControl.Start1Code">
The table is called PLUs
The form is called EPOSControl
The field to update from the form is called Starter1Description, it is on an unbound Form and unbound Text Box
The field to update in the table is called Desc (Stored as Text)
The field to select which row to update is called Code (Stored as Text)
I can manually update it in the table or by using an update query, so I believe it is my line of code that is wrong, but I can't see where.
Many thanks,
Malcolm
I have a table called PLUs, I need to update the value of the field called Desc from an unbound field on a form.
I am trying the following line of code and cannot see what is wrong with it, please can you help?
<DoCmd.RunSQL "UPDATE PLUs SET Desc = Forms.EPOSControl.Starter1Description WHERE Code = '1118'">
or
<DoCmd.RunSQL "UPDATE PLUs SET Desc = Forms.EPOSControl.Starter1Description WHERE Code = Forms.EPOSControl.Start1Code">
The table is called PLUs
The form is called EPOSControl
The field to update from the form is called Starter1Description, it is on an unbound Form and unbound Text Box
The field to update in the table is called Desc (Stored as Text)
The field to select which row to update is called Code (Stored as Text)
I can manually update it in the table or by using an update query, so I believe it is my line of code that is wrong, but I can't see where.
Many thanks,
Malcolm