Recent content by 1961templar

Well a big thank you to everyone that has contributed to this thread, especially to: boblarson, Mr. B, Kryst51 and wiklendt. I have now got the Form that automatically enters M (=Male) for Mr and F (=Female) for Mrs, Miss or Ms and the message box "please enter gender" for Dr (or any other...

This throws up a compile error: Expected Function or variable

Thanks for this it works great up to a point. When title = Dr, gender is automatically entered as "unk" = unknown, but I need to be able to manually enter M or F? I don't seem to be able to overwrite this "unk"?

Run-time error '13': Type mismatch Debugger highlights in yellow: If Me.cboTitle = "Mrs" Or "Miss" Or "Ms" Then

Here is a 2003 version.

The code I have been given does not run. If you look at my post 11-23-2009 02:41 PM I have attached a copy of my file (before adding the missing "End If") if you care to take a look? Thanks.

I added the extra "End If" but it still isn't working?

I originally used the code suggested by Mr. B. That code worked but when I modified it to match your suggestion it no longer matched gender to title. I have attached a copy for you to see. Thanks

I can't get this to run?

Ideally I would like Mr to force gender to M (male) Mrs, Miss and Ms to force gender to F (female) but non-specific gender titles such as Dr, Prof to force manual gender entry. Is this feasible?

Can anyone tell me how to modify this code to accommodate titles that are of non-specific gender e.g. Dr? Thanks!

Could this code be modified to allow non-specific gender titles such as Dr?

Kryst51 - did you attach your modified version of music_al's db?

I am not happy with the design now because its not possible to properly normalise with the limit on the number of tables. Also the data entry form for Emloyee is not ideal requiring a title ID to be entered (1,2,3,4) instead of Mr, Mrs, Miss or Ms. I can create a Form based on a query to show...

I had to consolidate two other tables to accommodate this. I still haven't heard back from the creator of the problem.