J
JohnE
There is a main form. On the main form is a subform (frmVersion) and on the
subform is another subform (sfrmVersionTask). The sfrmVersionTask is a
continuous form. There is a combobox on the sfrm that has items listed. At
the end of each record there is a button. This button opens up a popup form.
The popup form has a listbox. When the row in the listbox is selected, the
info for that record appears in the textboxes that are also on the popup
form. These are the same items in the sfrm combobox. What the user would
like is when the button is clicked and the popup form opens, the record is
already showing in the textboxes. The following line is what is used to open
the popup form. It is the where part that is not working correctly.
DoCmd.OpenForm "frmTaskList", , , "[TaskID] =
Forms![frmVersion]!Form![sfrmVersionTask]![cboTaskID]"
If anyone can diagnose the where part, great. Cuz I'm not getting it to work.
Thanks ... John
subform is another subform (sfrmVersionTask). The sfrmVersionTask is a
continuous form. There is a combobox on the sfrm that has items listed. At
the end of each record there is a button. This button opens up a popup form.
The popup form has a listbox. When the row in the listbox is selected, the
info for that record appears in the textboxes that are also on the popup
form. These are the same items in the sfrm combobox. What the user would
like is when the button is clicked and the popup form opens, the record is
already showing in the textboxes. The following line is what is used to open
the popup form. It is the where part that is not working correctly.
DoCmd.OpenForm "frmTaskList", , , "[TaskID] =
Forms![frmVersion]!Form![sfrmVersionTask]![cboTaskID]"
If anyone can diagnose the where part, great. Cuz I'm not getting it to work.
Thanks ... John