On Change Code - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

On Change Code

Chun Sing Alex Wu

4 years ago

I would like to write an onchange event: a date field from null to a date, then trigger another text filed change. Pls can you help?

	Adam Schwanz @Reply 4 years ago
Need more information, so you're changing a date field and then you want to trigger another field to change. What is the other field changing to? I would probably use after update over on change though

	Chun Sing Alex Wu OP @Reply 4 years ago
Hi, Thanks for your quick reply. This is another text field, actually it is a veiled call ''status''. Eg from ''awaiting quote response'' to ''quotes confirmed '' Thanks

	Adam Schwanz @Reply 4 years ago
Yea just make an after-update event on the date field, if you are using a date picker you could use on-change. Then just put the code to `OtherField = "Quotes Confirmed"` Or whatever else you want, Center Vertically and Intro to VBA might help you

	Adam Schwanz @Reply 4 years ago
I don't know why that link went to center vertically LOL, AfterUpdate

	Scott Axton @Reply 4 years ago
Adam ID 1729 vs ID 1279 - Transposition.

	Adam Schwanz @Reply 4 years ago
Are you saying that was a PEBCAK error Scott ;). Very possible LOL.

	Scott Axton @Reply 4 years ago
Adam - Nah just fat fingers

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View