Newdie Data Validation Question

[mchris]

Hello-

I'm new to access and VBA, but I'm catching on quickly.

I have what I think is i simple question, but I haven't been able to find an answer to it yet.

I have multiple bound fields on a form that I would like to validate when the user attempts to move to the next field.

I've tried using the Like and Dlookup functions, but I'm not having any sucess.

Can anyone refer me to a document or source that can help me???

Thanks

 

[mchris]

Let me clarify

After reading what I typed out of frustration, I thought I should clarify a bit.

Basically, what I want to do is this:

Take the value that is in the text box and when the user tabs to the next field, I want to validate it. The value in the text box should be a value in a specific row in a table.

For example, in my database there is a form that tracks contact information for inbound sales calls.

Some fields I want to validate are AgentID (the ID of the agent who took the call), State (make sure that the value entered is a valid US state abbreviation), and zip code (I have a table containing 74300 or so zip codes, I want to make sure the zip code entered is in this field. Ideally, upon entering the zip code the state and city fields would autopopulate, but this seems difficult).

Now that I'm moving on to a different problem hopefully I have described it more clearly.