Adding default letter to entry in textbox on form

[billybeer]

I have a textbox on a form that sets parameters on a query. I want there to be a letter automatically added to the beginning of the set of numbers that the user inputs. So the user should input 5 numbers and I want the letter "P" added to that number to be sent to the query. 45363 should become P45363. Thanks.

[CJ_London]

just at the P in your query


WHERE somefield="P" & [Forms]![Someform]![somefield]