Entering userID without seeing list

  • Thread starter Thread starter josh
  • Start date Start date
J

josh

I'm making a form where a user enters his user number, a
7 digit code that will go along with a log.
the 2 fields are userID and Memo

so far i've only been able to have all user id's in a
combo list box with limit to list on. I want the user to
have to enter his/her code and type the memo without
having all of the other user id's appear in the list box.
i also want the memo to be rejected if the user id doesnt
match one on record.

sorry if this is a noobie problem
 
this is sort of like password stuff.get rid of the combo
box. in your code slip in a DLookup function that uses the
users ID as criteria. if DLookup finds something then
they're in. if not msgbox"you're not on the list",clear
form, exit sub.
 
Back
Top