Validation Rule assistance

G

GerSmith

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?
 

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 Error Messages 1
Validation Rules for a Control on a Form (?) 4
Validation Rule Popup 1
Validation Rule 3
Validation in child form 1
Access Validation rule of 1 field based on a field of another table 1
DATA VALIDATION RULE BASED VARIED ENTRIES IN ANOTHER FIELD 1
Validation before adding record 5

Top