Y
Yeahyeahyeah
Per the instructions detailed here...
http://www.fontstuff.com/access/acctut08.htm
....I created a parameter query in the form of a drop down box that, once an
option is selected, should display a form with a number of fields pre-filled
from a record chosen by the drop-down selection.
The drop down has a command button with the following code in the Onclick
event:
Private Sub cmdCreateReport_Click()
DoCmd.OpenQuery "qryUIRFollowUp", acViewNormal, acEdit
DoCmd.Close acForm, "frmOpenUIRLookUp"
As it now stands when I click the button I get the form but none of the
selected data is filled in. The fields are blank.
What code to I need to add to the above to make the form hold the data
selected from the drop down?
Thanks,
David
http://www.fontstuff.com/access/acctut08.htm
....I created a parameter query in the form of a drop down box that, once an
option is selected, should display a form with a number of fields pre-filled
from a record chosen by the drop-down selection.
The drop down has a command button with the following code in the Onclick
event:
Private Sub cmdCreateReport_Click()
DoCmd.OpenQuery "qryUIRFollowUp", acViewNormal, acEdit
DoCmd.Close acForm, "frmOpenUIRLookUp"
As it now stands when I click the button I get the form but none of the
selected data is filled in. The fields are blank.
What code to I need to add to the above to make the form hold the data
selected from the drop down?
Thanks,
David