Search results

I've been using code to validate data on the same form. For example if one field contains data then another field must not be null or if field1 = 2 then field5 cannot = 4 etc. My question is how do I reference information on a subform. I want to do things like if the mainform's [field_x] is a 3...

I have a main form with general crash info and a subform with vehicles involved info, I need to do things like if the crash form indicates a train, moped etc. then there must be at least two records in the vehicle subform for that crash or if the crash indicates that a pedestrian was involved...

How can I require or convert to uppercase letters in text boxes on a form? Some special characters are allowed. Thanks ahead for any help!

I have fields for driver and car owner information. Like first name, last name, address etc. I would like to be able to check a box or click on something like "owner is driver" and populate the owner information with the driver info to save on data entry, but only if the owner is indeed the same...

How do I not allow a user to enter special characters or numbers in a field on a form - only text. ei a persons name with no numbers or special characters but do allow space or a dash? Thanks ahead to anyone who can help.

I have one field on a form with a drop down list and choices are "1", "2", "3". If 3 is picked then I want to force the user to put in a value in a different field on the form, without always forcing it. The user must be able to leave it blank at times. Also, if 1 or 2 is picked then I want the...