mtagliaferri
Registered User.
- Local time
- Today, 07:03
- Joined
- Jul 16, 2006
- Messages
- 550
I have copied a fully functional code from another form in the DB for selecting a specific record when double clicking on a field, but I receive this error:
"Syntax Error (missing operator)In Query Expression '[HotelLoyaltyProgram]=CLUB CARLSON'
"Syntax Error (missing operator)In Query Expression '[HotelLoyaltyProgram]=CLUB CARLSON'
Code:
On Error GoTo HotelLoyaltyProgramme_DblClick_Err
DoCmd.OpenForm "frmHotelLoyaltyProgramme", acNormal, "", "[HotelLoyaltyProgramme]=" & HotelLoyaltyProgramme, , acDialog
HotelLoyaltyProgramme_DblClick_Exit:
Exit Sub
HotelLoyaltyProgramme_DblClick_Err:
MsgBox Error$
Resume HotelLoyaltyProgramme_DblClick_Exit