DoCmd.openform "CurrWorkOrder", , , "[WorkOrderID]=" & "'" & Me.List.Column(2) & "'"
Apparently WorkOrderID has to be in text format for the openform command to work. If I change it to autonumber which is what I want, it gives me runtime error 2501.
My first question is does it really have to be in text format
If it does how do i auto generate WorkOrderID like an autonumber
I have been struggling with this for quite some time so any help will be greatly appreciated