RuralGuy thank you so much for your help so far. I tried what you suggested and it did not really give me what I was looking for. Please bear with me. I am not much of a technical writer. Let me try again.
I have a data entry form linked to an invoice table. The table has an index on the...
Thanks for responding RuralGuy but I am not quite sure we are on the same page. As soon as the focus moves to another control on the form I want Access to test if the data that was entered in the control that just lost focus is valid based on the validation rule rather than waiting until a new...
Hello All,
I have a form that allows users to enter invoice numbers into an invoice number field that is stored in an invoice table. There is a validation rule that prohibits entry of invoice numbers that have been previously entered. This is an accounts payable operation and the invoice...
Hello folks,
Just taking the time to introduce myself. I am new to the Access Forum and basically new to forums in general. I am from New York and work in city government. I have been assigned to a database project by default and do not really have a clue about some of the things I need...