Software

Ask something
Discussion Locked

Form Field Validation in Access

0 helpful
1 reply

by xpertdragon 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

This is a question for all MS Access experts out there. I am looking to just make a simple form within Access 2000 that does validation based on records from a Table within the same database.

For instance, if a table had a field that listed HelpDesk ticket status, such as (Urgent, Very Urgent, No Rush priority, etc.) and someone was entering the corresponding status in a Form field, and they entered an invalid status, it would give them a message warning, or other warning.

I am looking for any VB code examples that may be applicable, or directions to perform this with given steps in Access 2000.

Pointing me to a "related topic" web site would be helpful as well. Thanks.

Paul

1 reply

by glen_mcleod

Rather that providing a text field and trusting the user, just put the valid choices into a combo and validate that one has been selected, i.e. that the combo's listindex is diferent than -1. The advantage to this is that if you ever need to add new choices, you update the database table with the new entries and the combo gets them automaticaly.

Glen

This discussion is closed to new replies.