Is pnummer defined as a Text Datatype or a Number Datatype?
"pnummer = '" & Me.Pnummer & "'"
is the correct syntax if the Field is defined as Text, but for a Numeric Field the correct syntax would be
"pnummer = " & Me.Pnummer
The other thing I wonder about is whether the Field and Control that holds the person's personell number is actually pnummer, as you have it in your code, or if it should be pnumber.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007