change field value on change of other field in form

A

ACCESS NEWB

Registered User.
Local time
Today, 16:35
Joined
Feb 12, 2008
Messages
64
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
 
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)
 
In the OnChange event for the first text box put something like:

me.INOUT = me.RETURNDATE
 
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
 
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

???
 
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
 
Can you post enough of your database for me to take a look at?
 
You must log in or register to reply here.

Similar threads

J
Code to change Date in a field if the checkbox is checked
Replies
5
Views
221
LarryE
LarryE
O
Change color depending on the field value
Replies
9
Views
586
Gasman
Gasman
J
Solved Vb error on changing the color of a two fields
Replies
10
Views
266
Jomat
J
B
Trigger event by writing value to a field
Replies
7
Views
311
CJ_London
C
A
Having trouble with a combo box
Replies
17
Views
529
Pat Hartman
P

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom