D
Damo G
Hi team,
Have scoured all of the posts and tried several different things for days
but just can't seem to nut this one out.
I have a form (FrmSeedBankStockAvailable) in datasheet view that lists seed
lots by BatchID. I want to be able to double click on the record selector
for a particular batch and have a form (DialogSeedBankWithdrawal) open so
that I can make a new withdrawal entry, with the BatchID already entered from
the selected record. I know that to do this I need to use the forms'
DblClick property. I have been using the following code (and tried
variations of from other posts).
DoCmd.OpenForm "DialogSeedBankWithdrawal", , , "[BatchID] = " & Me!BatchID,
acFormAdd
Some of the time I just get a blank form, and other times when I got the
code close it would ask for the paratmeter but the particular batch ID would
be in the pop up. I know it is probably something very simple.
Thanks in advance for anyone who can help.
Damo G
Have scoured all of the posts and tried several different things for days
but just can't seem to nut this one out.
I have a form (FrmSeedBankStockAvailable) in datasheet view that lists seed
lots by BatchID. I want to be able to double click on the record selector
for a particular batch and have a form (DialogSeedBankWithdrawal) open so
that I can make a new withdrawal entry, with the BatchID already entered from
the selected record. I know that to do this I need to use the forms'
DblClick property. I have been using the following code (and tried
variations of from other posts).
DoCmd.OpenForm "DialogSeedBankWithdrawal", , , "[BatchID] = " & Me!BatchID,
acFormAdd
Some of the time I just get a blank form, and other times when I got the
code close it would ask for the paratmeter but the particular batch ID would
be in the pop up. I know it is probably something very simple.
Thanks in advance for anyone who can help.
Damo G