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?
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?