Validation Rule assistance


Joined
Aug 15, 2013
Messages
1
Reaction score
0
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?
 
Ad

Advertisements


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

Similar Threads

Validation Rule 4
Validation Rule 0
Validation Rules 2
Help!!! Validation Rule 1
Validation Rule question 1
validation rule on form 1
Validation rule question 3
validation rule problem 1

Top