Limit to List - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Limit to List

Richard Pitassy

4 years ago

I haved a lookup combo box set to Limit to List. Is there a way to provide my own message to the user if the value entered is not in the list rather than the Access generated message?

	Kevin Robertson @Reply 4 years ago
This requires a little bit of VBA. See Relational Combo Boxes Extended Cut (On Not In List Event)

	Richard Pitassy OP @Reply 4 years ago
Thanks Kevin. Will check it out.

	John Davy @Reply 4 years ago
Hi Kevin, Try watching Richards Tech Help Video -extended on Relational Combo Boxes about 12 1/2 min into the video HTH John

	Kevin Robertson @Reply 4 years ago
John, I'm not sure what you are referring to at that timestamp.

	John Davy @Reply 4 years ago
Hi Kevin, Watch the entire Tech Help Video John

	Alex Hedley @Reply 4 years ago
@John, the OP is Richard, not Kevin. Kevin already suggested they watch the video you then added after

	Richard Pitassy OP @Reply 4 years ago
Thanks everyone. Kevin's suggestion was right on the money. Dick

	John Davy @Reply 4 years ago
Hi Kevin, Sorry about my screwup. John

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

Next Unseen

New Feature: Comment Live View