form opening

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top