combo box restriction

[bigmac]

hello all, can you help please, I have a combo box "updated by" this has a list of all employees that use the database, they all log on and have a lngEmpID number , what I what is that if tom smith logs on and uses the combo box then it will only update if he uses his name from the drop box list, if he tries to use someone else's name then it will show an error message and will not let him do this until he uses his own name .
can you show me the code I need for the after update please.

 

[Mile-O]

Start by googling for fOSUsername(), which is some code that will give the user's name.

In the table that holds the user data, add a field for their system ID and add them.

Then, on your form, you can do a comparison with the user selected and their fOSUsername().

Plenty of threads on this topic throughout the forum.