Web Development

Ask something
Discussion Locked

Form Field Validation in Access 2000

0 helpful
3 replies

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 Help Desk 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

3 replies

by pancras

Maybe i am not getting the point but this is a basic thing in access which can be handled with a
combobox. this combobox can be populated with rows from another table. this combined with the combobox 'limit to list' property should restrict the user to valid entries.

by xpertdragon

Yes, I agree with you, and have taken your suggestion to implement simple combo boxes. If you are aware of how to create something like a Sub-database in the Forms window that shows all accumulated records and fields at the bottom as they are cycled or clicked through, please let me know by email. (paulmchavez@yahoo.com).

Thanks again!

Paul

This discussion is closed to new replies.