Dropdown Not Working - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Dropdown Not Working

Ronald de Boer

14 months ago

Hi,
Below I have a screenshot where the dropdown is not working. I have no idea why. Strangely on the 1st record in the continuous form it does dropdown as it should but not subsequently for 2nd and subsequent records.

The Code to setup for record 1 in the continuopus form is the Sub LocationField_LostFocus()

The code subsequently for records 2 and onward are attached are Sub SelectClusterCombo_GotFocus() and SelectClusterCombo_LostFocus()

Once the Location field has been set the only thing for all records being created are created/setup in SelectClusterCombo

Any idea why this isn't working.

Regards
Ron dB

	Ronald de Boer OP @Reply 14 months ago

	Ronald de Boer OP @Reply 14 months ago

	Ronald de Boer OP @Reply 14 months ago

	John Davy @Reply 14 months ago
Take a look at Richard's videp https://599cd.com/blog/display-article.asp?ID=2775 john

	Ronald de Boer OP @Reply 14 months ago
Thanks, will do

Ronald de Boer OP @Reply

14 months ago

Hi,

The ComboBox works perfectly. What is not happening after the 1st record in the Continuous form is the dropdown!

The logic of the program gets the user to enter 2 fields in the Form Header and then sets GotFocus to SelectClusterCombo. The user can select from the ComboBox for the 1st record. After selection various bits of code occurs the record is written and focus is set again to SelectClusterCombo but on GotFocus the dropdown does not work. The only field required user entry is this field. Is this causing the problem

Regards

Ron de Boer

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

Next Unseen

New Feature: Comment Live View