Carolyn Johnson
cjlabs at worldnet.att.net
Sat Jul 18 13:07:07 CDT 2009
WinXP Access2003
I have a form/subform with a command button that finds a record based on a field for the subform. If I click the command button on the subform, the code works correctly. If I use the hotkey for the command button (alt + G), the correct record is found (seen by stepping through the code), but then the form reverts back to the first record.
Code for command button:
currentItem is determined by a combobox on a separate form -- the item being searched
currentCategory = DLookup("CategoryID", "tblItem", "[ItemID] = " & currentItem)
Forms![frmCategoryData].RecordsetClone.FindFirst "[CategoryID] = " & currentCategory
Forms![frmCategoryData].Bookmark = Forms![frmCategoryData].RecordsetClone.Bookmark
Forms![frmCategoryData]![frmItemData].Form.RecordsetClone.FindFirst "[ItemID] = " & currentItem
Forms![frmCategoryData]![frmItemData].Form.Bookmark = Me.RecordsetClone.Bookmark
Since the command button is on the subform, the last 2 lines of code were originally
Me.Recordsetclone.FindFirst "[ItemID] = " & currentItem
Me.Bookmark = Me.RecordsetClone.Bookmark
I was concerned that the location of the active control when the hot key combination was entered might cause the Me keyword not to work, so I have put the form name, but that still doesn't get the hot key combination to work.
What is different about using a hotkey to trigger the code compared to clicking the command button?
Thanks
Carolyn Johnson
St Louis, MO