Validation rules in Access

  Gary Wood 11:53 24 Feb 06

One of the fields in a table in my Access database is a lookup field which allows users to select a value from a drop down list of the records in another table.

Can anyone tell me how I can validate the input to make sure that even if the user types a value into the box instead of selecting from a dropdown, the value is still one of those featured in the drop down list?

  Crunchy 13:48 24 Feb 06

Go into the properties of your combo dropdown box and make sure "Limit to List" is set to Yes should do the trick.

  Belatucadrus 17:21 24 Feb 06

Or open the table relationships and tick "Enforce referential integrity"

  keith-236785 17:45 24 Feb 06

or write a small bit of VB code along the lines of

AllowEdit = false

for the dropdown box so they cant type anything into it....limiting them to only the items available in the dropdown.

This thread is now locked and can not be replied to.

LG G6 review: Hands-on with LG’s bold, big-screen shot at perfection

1995-2015: How technology has changed the world in 20 years

How the 2017 Oscar-winning VFX of The Jungle Book were created

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…