After Update Event - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

After Update Event

Mark Parsons

5 years ago

Hi all, I new to access and having a real issue with a problem I have. Within a form I have a combo box, that managers select an option from. In this case sickness, when they select this option I want to either show tick boxes when sickness is selected or hide if another value is selected.

Is this possible? I have tried to write code but I keep getting errors coming up?

	Adam Schwanz @Reply 5 years ago
So you want to change whats visible on the form based on what is selected in the combo box? All you need is an after update event in the combo box If comboboxname = sickness then Controlname.visible = false End if

	Adam Schwanz @Reply 5 years ago
Not sure why it cuts off my quotations on iphone. Youll need them around the word sickness.

	Alex Hedley @Reply 5 years ago
Adam you need to swap them from smart quotes to "

	Adam Schwanz @Reply 5 years ago
Ah that explains it. Thanks Alex

	Richard Rost @Reply 5 years ago
What Adam said is correct, however remember this is a lot more advanced. I see you're just a Beginner user. This is covered in detail when you get to the Advanced and Developer classes. Here's a TechHelp video that will help: AfterUpdate

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

Next Unseen

New Feature: Comment Live View