Text replacing text after update (1 Viewer)

A

aattas

Registered User.

Local time

Today, 02:39

Joined

Dec 24, 2014

Messages

74

• Dec 10, 2018

• #1

Gents
I know this is suppose to be easy even for newbie like me but I couldn't get the text of a field to change to another text after update permanently.
I used:
If me.type = new then me.type =old.

It worked most of the time, but sometimes the text "new" got stuck and no change to old.
Any suggestions?

 

Ranman256

Well-known member

Local time

Yesterday, 19:39

Joined

Apr 9, 2015

Messages

4,339

• Dec 10, 2018

• #2

on a form for 1 record, you must use quotes.:
If me.type = 'new' then me.type ='old'.

or
create an update query
update table set [type]='old' where [type]='new'

or for 1 record:
update table set [type]='old' where [type]='new' and [id]=forms!myForm!txtID

 

A

aattas

Registered User.

Local time

Today, 02:39

Joined

Dec 24, 2014

Messages

74

• Dec 10, 2018

• #3

Much thanks. I will try them and will let u know.
Cheers