R
RonBoy05
I have a form that I am trying to simplify. Once this form is updated I need
to transfer the data to another table. This table is formatted for a text
dump. Once the text is dumped, it can't be dumped again. So the command I
would like to do is after one field is updated, another field will have the
value of 1 placed in it. That record will then be appended to the other
table by the criteria of 1 in the toVR field.
This should be really simple, but for someone that is fumbling his way
around access, I am stumped. I can't find the right information in help.
Here is the command.
Private Sub DateRecieved_AfterUpdate()
'Append record to VR table
AddDataSt.ToVR = "1"
DoCmd.OpenQuery QueryAppendVR
End Sub
to transfer the data to another table. This table is formatted for a text
dump. Once the text is dumped, it can't be dumped again. So the command I
would like to do is after one field is updated, another field will have the
value of 1 placed in it. That record will then be appended to the other
table by the criteria of 1 in the toVR field.
This should be really simple, but for someone that is fumbling his way
around access, I am stumped. I can't find the right information in help.
Here is the command.
Private Sub DateRecieved_AfterUpdate()
'Append record to VR table
AddDataSt.ToVR = "1"
DoCmd.OpenQuery QueryAppendVR
End Sub