change field value on change of other field in form (1 Viewer)

A

ACCESS NEWB

Registered User.

Local time

Today, 20:10

Joined

Feb 12, 2008

Messages

64

• Apr 2, 2008

• #1

What I want to do is following.
In form ASSIGN(fields are takedate and inout) ,if TAKEDATE is different then 0 then set value of inout field to 1
My VBA knowledge is poor cause i dont think this should be hard

thanks in advance

 

KenHigg

Registered User

Local time

Today, 14:10

Joined

Jun 9, 2004

Messages

13,327

• Apr 2, 2008

• #2

ACCESS NEWB said:

...
My VBA knowledge is poor cause i dont think this should be hard

Click to expand...

.
.
.
.
???

 

A

ACCESS NEWB

Registered User.

Local time

Today, 20:10

Joined

Feb 12, 2008

Messages

64

• Apr 2, 2008

• #3

english isnt my native as you can see,so let me try again.
I would like that when I enter some value to field RETURNDATE ( In form ASSIGN) that action automatically change value of field INOUT(also in that form) to value lets say 1.
(Field INOUT will be invisible)

 

KenHigg

Registered User

Local time

Today, 14:10

Joined

Jun 9, 2004

Messages

13,327

• Apr 2, 2008

• #4

In the OnChange event for the first text box put something like:

me.INOUT = me.RETURNDATE

 

A

ACCESS NEWB

Registered User.

Local time

Today, 20:10

Joined

Feb 12, 2008

Messages

64

• Apr 2, 2008

• #5

You didnt understand me.
when RETURNDATE is entered i want that to trigger change of value of field INOUT to 1 (its default value is 0)
So some kind of IF should be applied i presume

 

KenHigg

Registered User

Local time

Today, 14:10

Joined

Jun 9, 2004

Messages

13,327

• Apr 2, 2008

• #6

ACCESS NEWB said:

You didnt understand me.

Click to expand...

Allow me to provide a bit of 'English' etiquette: When asking for a favor, i.e. asking to help figure out your code, you may want to assume the error of poor communication by replacing 'You didn’t understand me' to 'I failed to explain my self clearly'.


At any rate, in the OnChange event for the first text box put something like:

me.INOUT = 0

???

 

A

ACCESS NEWB

Registered User.

Local time

Today, 20:10

Joined

Feb 12, 2008

Messages

64

• Apr 2, 2008

• #7

forgive me,I am trying whole day to make this work,and this is a missing link ,and
you are absolutely right.
But I still do not understand how will INOUT get value 1 if I just add code you put in previous post in RETURNDATE ?


P.S. I am humble and very greatfull for help I receive from this forum

 

KenHigg

Registered User

Local time

Today, 14:10

Joined

Jun 9, 2004

Messages

13,327

• Apr 3, 2008

• #8

Can you post enough of your database for me to take a look at?

 

A

ACCESS NEWB

Registered User.

Local time

Today, 20:10

Joined

Feb 12, 2008

Messages

64

• Apr 3, 2008

• #9

I figure it out thank you