|
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
(Edited by HansV – queries displayed in table form)
I’m trying to create a couple of synchronized combo boxes, but I keep getting a parameter box coming up when I open my form, and it’s asking for a StudID. Here’s how I have it setup:
Student List query
| Field: | StudID | FirstName | LastName |
| Table: | tblStudent | tblStudent | tblStudent |
| Sort: |
Nope, it doesn’t make any difference. 
Try this then:
– Open the form in design view.
– Clear the Row Source of Combo15.
– Change the After Update event procedure for Combo9, substituting the correct name
Private Sub Combo9.AfterUpdate()
Me!Combo15.RowSource = “Exact name of invoice list query”
Me!Combo15.Requery
Me!Combo15.SetFocus
End Sub
Tip for future development: I recommend giving controls meaningful names. If you have to perform maintenance on the database after months of not working with it, a name such as cboStudentList or cboInvoiceList is much easier than Combo9 or Combo15. 
Well, it’s finally working. I finally figured out what my problem was. I still had remnants of a subform still on my form. That’s why it was wanting that parameter. 
I also took your advice on naming controls. I guess I was just concered with trying to get it to work, than with the names. Thanks.
Glad you found it! This kind of thing can be hard to trace. 
Glad you found it! This kind of thing can be hard to trace.
Well, it’s finally working. I finally figured out what my problem was. I still had remnants of a subform still on my form. That’s why it was wanting that parameter.
I also took your advice on naming controls. I guess I was just concered with trying to get it to work, than with the names. Thanks.
Try this then:
– Open the form in design view.
– Clear the Row Source of Combo15.
– Change the After Update event procedure for Combo9, substituting the correct name
Private Sub Combo9.AfterUpdate()
Me!Combo15.RowSource = “Exact name of invoice list query”
Me!Combo15.Requery
Me!Combo15.SetFocus
End Sub
Tip for future development: I recommend giving controls meaningful names. If you have to perform maintenance on the database after months of not working with it, a name such as cboStudentList or cboInvoiceList is much easier than Combo9 or Combo15.
Nope, it doesn’t make any difference.
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
