Validation against Query Results

[Ebes1099]

I'm trying to makie a validation rule for a field on my form based on the results of a query. I only want the user to be able to enter certain Account Numbers. I made a query that returns the Account Numbers I want the user to be able to enter. Then if I go into the field on the form and do validation and put...

In [Accts Query][Accounts]

it gives me some error saying it doesn't contain the automation object.

How can I get the validation to work using the results of the query?

 

[dhookom]

Why not just use a combo box that is limited to the list?

Duane
Hook'D on Access
MS Access MVP

 

[Ebes1099]

Yea I guess I could do that. It might look nicer if I can use validation since the fields all below it are just plain text boxes. Would the validation rule be difficult to implement on a text box?

 

[dhookom]

You could probably use DCount() in code after update to see if the value is in the query. If DCount() returns 0, you can set the value back to Null.

Duane
Hook'D on Access
MS Access MVP