G
Guest
I have a VBA error routine embedded in a Form that if triggered opens a
second form whose record source is a querry. In the original form, I have an
ID number which I want to use as a "criteria" for the ID field in the
querry. Can I take the variable holding the ID number in the original form,
and pass it to the new form, which in turn would selectively open the querry
with this as the criteria for the ID field?
So the code in frmOriginal is:
vID=3
DoCmd.OpenForm "frmTestPassthrough", acPreview, , , , acDialog
and then I am lost.
The reason I use the acDialog is because I will come back to the original
form after manipulating the data in the newly opened form.
As always, I appreciate the help of this group forum.
Gene
second form whose record source is a querry. In the original form, I have an
ID number which I want to use as a "criteria" for the ID field in the
querry. Can I take the variable holding the ID number in the original form,
and pass it to the new form, which in turn would selectively open the querry
with this as the criteria for the ID field?
So the code in frmOriginal is:
vID=3
DoCmd.OpenForm "frmTestPassthrough", acPreview, , , , acDialog
and then I am lost.
The reason I use the acDialog is because I will come back to the original
form after manipulating the data in the newly opened form.
As always, I appreciate the help of this group forum.
Gene