Setting Values

D

DS

How do you set the value in a table? I have a Subform that has a
record in it. It contains a value that is placed there from a popup
form. It has the RecordID from another table that is not used in this
subform. When I delete this record I need it to go to the table where
it came from and reset a value in that table. How do I refrence the table?

TableName!FieldName = 0

Is this right?

Thanks DS
 
J

John Vinson

How do you set the value in a table? I have a Subform that has a
record in it. It contains a value that is placed there from a popup
form. It has the RecordID from another table that is not used in this
subform. When I delete this record I need it to go to the table where
it came from and reset a value in that table. How do I refrence the table?

TableName!FieldName = 0

Is this right?

Thanks DS
Click to expand...

No, it's not. You can't reference a table in that way.

You'll need to run either an Update query (to update the value of the
field in an existing record) or an Append query (to add a new record).

John W. Vinson[MVP]
 
D

DS

John said:
No, it's not. You can't reference a table in that way.

You'll need to run either an Update query (to update the value of the
field in an existing record) or an Append query (to add a new record).

John W. Vinson[MVP]
Click to expand...
Thanks John,
I've decided on a DLookUp and then I'm trying to set the value. (See
DLookUp not working.
Thanks
DS
 
Top