krishnanhemanth
Registered User.
- Local time
- Tomorrow, 03:07
- Joined
- Jun 12, 2009
- Messages
- 115
hi everybody
i have a field in my table called "PAY STATUS"----a YES/NO TYPE FIELD
on the form i have 3 calculated textboxes
1st Textbox is --- "PAYMENTS RECIEVED"
2nd Textbox is --- "PAYMENTS PENDING"
3rd Textbox is ---- "payments balance" ( "PAYMENTS PENDING - "PAYMENTS RECIEVED")
wHAT I WANT IS WHEN "PAYMENTS RECIEVED" EQUALS "PAYMENTS PENDING" OR
WHEN "PAYMENTS BALANCE" BECOMES ZERO.....THEN
THE "PAY STATUS" SHOULD BE POPULATED AUTOMATICALLY
THANKS IN ADVANCE
HEMANTH
i have a field in my table called "PAY STATUS"----a YES/NO TYPE FIELD
on the form i have 3 calculated textboxes
1st Textbox is --- "PAYMENTS RECIEVED"
2nd Textbox is --- "PAYMENTS PENDING"
3rd Textbox is ---- "payments balance" ( "PAYMENTS PENDING - "PAYMENTS RECIEVED")
wHAT I WANT IS WHEN "PAYMENTS RECIEVED" EQUALS "PAYMENTS PENDING" OR
WHEN "PAYMENTS BALANCE" BECOMES ZERO.....THEN
THE "PAY STATUS" SHOULD BE POPULATED AUTOMATICALLY
THANKS IN ADVANCE
HEMANTH