Validation Rule assistance

Aug 15, 2013
Reaction score
Hi there,

I am new to this site but have previously gotten great use from it - thanks.

I am new to using access and have to perform a task in a table i hope someone can help.

Here is my issue and thanks in advance:

I have a form in access based on a table called tblFile. I want to condition either the form or the table with some sort of validation rule that has below requirement based on fields in the one tbl (tblFile):

My fields are:
Location (which contains lookup from seperate table)
ArchiveBarcode (text field)

I wish to create a validation rule which conditions the ArchiveBarcode field. The condition is that if location = "archives", then populate the ArchiveBarcode field.

Is such possible and if so, what would you suggest and where would I placed it?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question