Using a form field for UPDATE query WHERE value (1 Viewer)

R

RJW

Registered User.

Local time

Today, 04:37

Joined

Sep 21, 2006

Messages

44

• May 24, 2018

• #1

Sorry for the simple question ...

I have this line which works

CurrentDb.Execute "UPDATE Responses SET FollowUp = 0 WHERE ID = 131"

But I need the value for the WHERE ID =
to be a value of a field on the current loaded form.

Form Name: Response
Field Name: Text33

I can't seem to get the syntax right.

Thanks

 

June7

AWF VIP

Local time

Today, 00:37

Joined

Mar 9, 2014

Messages

5,468

• May 24, 2018

• #2

What did you attempt?

Concatenate variable inputs.

CurrentDb.Execute "UPDATE Responses SET FollowUp = 0 WHERE ID = " & Me.Text33

 

R

RJW

Registered User.

Local time

Today, 04:37

Joined

Sep 21, 2006

Messages

44

• May 24, 2018

• #3

I tried to many things to list them here. And I'd be embarrassed listing some of them.

Your suggestion worked.

Thanks June7