Referencing form Fields

[sbouley7]

I've been working with VBA in access for a while but there's been one thing I never could get the hang of.

I'm trying to update a record in VBA. The value to update and the criteria are contained in fields on the same form but I could never figure out the syntax for referencing different data types.

Here's the code:

DoCmd.RunSQL "Update tbl_Offering SET Transaction_ID = Me.ID WHERE "Offering_ID =" & Me.txt_offering_ID"

If someone could point me to a good tutorial it would be great.

Thank you.

[zmbd]

Ah,
My infamous tutorial list...
Please check your bytes.com inbox for the boiler plate. (^_^)

If the form is bound to a data source; thus, the controls are most likely also bound, then the updates are quite forward.

All of that covered in the PM...