wow, other forums i have been on in the past have got super upset if the file was not attached to the thread.
When being used as a macro created by Access it works fine, except for the error if nothing is selected from the listbox, however that part is not important.
The code that was extracted from converting the macro to VBA is as follows
Code:
Private Sub Active_Edit_Button_Click()On Error GoTo Active_Edit_Button_Click_Err
' The line directly below is the one with error in it
Docmd.OpenForm "CustomerInfo_F", acNormal, "", "[ID]=" [&Active_Listbox], , acNormal
' The line directly above is the one with error in it
Active_Edit_Button_Click_Exit:
Exit Sub
Active_Edit_Button_Click_Err:
MsgBox Error$
Resume Active_Edit_Button_Click_Exit
End Sub