Hello again, perhaps I did not put enough detail. In the on click property I'm typing =showsystemdeta ils(1234) Showsystemdetai ls is the user defined function. the (1234) is the computer ID. This works perfectly when there are only numbers in the computer ID. It walks through the user defined function, opens the form named frmLookup with the details for computer 1234. If the computer ID includes a Letter, such as (D013456)....wh ich is how all...

I have a button on a form. in the on click I am calling a user defined function. If there are no letters it appears like this:
=showsystemdeta ils(12345)

if there are letters it autodefaults to this:
=showSystemDeta ils([D05013368])

Here is my code.

Public Function showSystemDetai ls(ID)
On Error GoTo showSystemDetai lsErr

Dim stDocName As String
...