save open arg data in table?

[Abbey Normal]

Hi. Hope this is easy. I have a form1 from which I am opening Form2, passing
the SKU thru the open args. I am opening Form2 in add mode, and the SKU is
appearing correctly on the form2. Form2's record source is the table
(auditlog).
On the form, I have another text field, reason, into which the user enters a
reason.
The reason is being saved to the auditlog table, but not the SKU. How can I
get the SKU to be saved in the table? Thanks,

 

[Jeff Boyce]

Is the control displaying the SKU "bound" to the auditlog's SKU field?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Abbey Normal]

No, when I view the form2 in design mode, the text appears "UNBOUND". If I
change the control source of that control to SKU, i get the error "you can't
assign a value to this object"

 

[Jeff Boyce]

Abbey

I don't think I have enough information to explain why you'd get that error,
but I do know that if your form doesn't know to connect the SKU control (a
textbox, not a label control) to the form's underlying source field in the
table, your form doesn't know how to update the underlying source field in
the table!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Abbey Normal]

I wonder if It anything to do with opening the form in add mode. (I am also
having trouble setting another data field) If I have the form open in add
mode, is there a way to set the table's data directly?

 

[Abbey Normal]

Nevermind! I found the answer in a post from Klatuu:
With Me.Recordset

.Edit
![ModifiedDate] = Now
.Update
End With

Which I put in the after Insert event on the form. I'm happy! Thanks for
your help.