Setting Values

[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

 

[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

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]

 

[DS]

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]

Thanks John,
I've decided on a DLookUp and then I'm trying to set the value. (See
DLookUp not working.
Thanks
DS