Samantha
still learning...
- Local time
- Yesterday, 23:05
- Joined
- Jul 12, 2012
- Messages
- 180
Hi all, I am using 2013 and always learning. This should be really simple although all of the variations I have tried haven't worked out. I am sure it is something simple that I am overlooking. The following code is located on my form frmProposalLog which is a datasheet based on qryProposalLog containing tblProposals.ArchiveBox which is a text lookup field.
In theory when double clicking the field on my datasheet I would like frmBoxLocation to open matching tblProposals.ArchiveBox with tblLookupBoxLocation.BoxLocation.
Code:
Private Sub ArchiveBox_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmBoxLocation", acNormal, , "[ArchiveBox]=" & Me.BoxNumber
End Sub
In theory when double clicking the field on my datasheet I would like frmBoxLocation to open matching tblProposals.ArchiveBox with tblLookupBoxLocation.BoxLocation.