Using different validation on dynamic controls

[JFo]

Here is a copy of my current database


Attachment 4780

If you go through frmMainMenu-->Select relevant combos and click on Add new Inspection-->fill in relevant details-->Add Equipment-->select equipment from combo box-->click in checklist form

The check-list form is populated with the questions for that specific piece of equipment type

What I want to be able to do is to validate the different answers with different coding. At the moment the answer is set up as a combo box, however ideally someone could enter anything they wanted as a response and different questions should be validated with different validation i.e whether a date, or a serial number was entered for example

Wondering if anyone knows how to do this for each question in the current set-up?

Would love an example of how to do it for two specific questions with different validation ie dtae and serial number and I can maybe figure out how to do it for the rest


Thanks

[June7]

You want users to always select answer from a standardized set of responses? You can restrict their choice according to the Equipment selected. Equipment can be restricted according to the Type selected. These are cascading (dependent) comboboxes. See this tutorial http://www.datapigtechnologies.com/f...combobox2.html

Set the dependent comboboxes as not Enabled until primary combobox selection is made then use code to Enable.

Otherwise will need to hard code the validation with Select Case and/or If Then Else structures.

[JFo]

Hi June7, thanks for checking out my problem

You want users to always select answer from a standardized set of responses? No they should be able to enter unique answers for any question however the common answers exist to save time

Thanks again for your response however I have already used many cascading combo boxes to get to my current position and every question has been filtered for the specific piece of equipment type.

What I need to be done will have to be handled in code you are correct, my difficulty is coding something like this and where to put it the code

for example to enforce a valid response is entered will have to be something like

Dim Answer As String
Dim testcheck As Boolean

if equipment type = 'a'
AND ChecklistID (Question) = '51'
testcheck = Answer = "B?T*"

This is not correct however theoretically something like this will return false if the answer does not start with a B or end in a t

I would like to be able to do some sort of validation if required on each answer however due to the fact I am dynamically populating the form I don't know where to put this code

Thanks

[June7]

Not sure I understand your requirements but will take a stab. Perhaps in the BeforeUpdate event of the answer combobox, something like:
If Me.tbxEquipmentType = "A" AND Me.tbxChecklistID="51" Then
If Not Me.cbxTestCheck Like "B*" And Not Me.cbxTestCheck Like "*T" Then
Cancel=True
EndIf
ElseIf
....
End If

[JFo]

U made my day June7, thanks

I got it to work finally, Great!!!