Search results

Hi, I have tried this but it keeps saying to debug the error? How do you know what number the column is? Will they still be numbered from 0 up if you originally have a normal form, but afterwards change the field in the form to a combo box in order to auto populate it? Thanks

No, there is no such thing as valid teacher's name. The teacher's names are not anywhere in the database. I would just like to ensure that in this field on the database table/field the names are entered in the form I stated.. not allowing them to input say just 'Patel' but ensuring they input...

Thank you very much.. However, it could be a range of teacher's name that I do not know. Will this still work? I just want to make sure that the user must type in Mr/Mrs/Ms/Miss and then a name?

I want to create a validation rule so that in my database table/form, in the 'Given by' field only correct teachers names can be entered in the form Mr/Ms/Miss/Mrs Patel I would like the rule to ensure Mr/Ms/Miss/Mrs is to be entered followed by a surname. Thank you in advance!