Validate field data

[jsbarroso]

:banghead:I have a form that contains two text fields i.e.; [Scat_text] and [STyp], which each can be changed by the users. I would like to combine the results of the two fields together and validate if the results exists in a query. What would be the best way to accomplish this?

 

[rzw0wr]

I assume you are wanting to concatenate the 2 fields Scat_text and STyp.

[Scat_text] & [STyp]
I would use this in the Before Update event.

Dale