New to ADP - ComboBox Filter Criteria

[LowBrow]

I've seen several similar questions to this, but I have not found any answers that work. Here's the problem - I am converting an mdb to an adp. A form used to open a report was based on a query that selected ConID (clientID), Comp_Date, and AIR_Date. On the form are three comboboxes: cboClientSelect, cboComp_Date, and cboAIR_Date. Once the user selects a client from the cboClientSelect, the records available in the other two controls are narrowed. This was handled by a criteria expression in the query like [Forms]![frmReport_Sel]![ConID].
This doesn't work in adp, and I cannot figure out how to do what is a relatively simple function. How do I limit options in a combobox on a form based on other selections made on the form in adp?

 

[TimKThailand]

Change the query to a stored procedure. Then check this

http://support.microsoft.com/default.aspx?scid=kb;en-us;300693&Product=acc

out.

 

[LowBrow]

Thanks TKT,
I will try this out this afternoon and get back to you. I appreciate your time!

 

[LowBrow]

TKT,
The example provided at the link has the user directly coding in the date range for the report. My problems related to this are:

I want to populate two lists of dates on the form for the user to select from (one is the incident date, the other is report initiated date). These dates are controled by which client the user selects from the initial drop down list.

I then want to pass the client/date combination to the report.

Since the code I am currently using references the unbound control cboClientSelect on the form, I cannot get the form to properly populate the two lists of dates. And if I do, how do I pass the date to the report?

This code example is very helpful for when I get to the report, but I need the correct data in the form first, then I need to pass the selected date from either list to the report. Any Ideas? Does anyone know if there are good examples of this in the NWindDB? I have seen some references that lists boxes are better for in adp than comboboxes. Is that true?

 

[TimKThailand]

Yes, there is a good exmaple in NorthwindCS.ADP. Check Sale by Year Dialog form out. It's related with Sale By Year report which based on Sale By Year stored procedure.

 

[LowBrow]

Thank a ton! I dig into that this afternoon!