Selasa, 30 Agustus 2011

[MS_AccessPros] Cascading Combo Boxes Values in a Query

 

Hi,
With your help (and thanks), I've created 3 unbound combo boxes on a form. The combos are cmbDirection, which cascades to cmbRunID, which then cascades to cmbDate.
Now that I have the values selected, I'm trying to view the data in a sub-form.
The sub-form was created based on a query.
I've tried to populate the sub-form by populating the sub-form's Link Master Fields property with the values cmbDirection;cmbRunId;cmbDate. I've populated the Link Child Fields with the values Direction;RunId;Date. All of the Link Child Fields are in the base sub-form query. When I use the form, the combo boxes populate correctly, but no data is returned in the sub-form.
Do I need to requery the sub-form somehow to get data to the sub-form or am I misusing the Link Master/Child properties?
Thanks,
Terry

__._,_.___
Recent Activity:
MARKETPLACE
A bad score is 596. A good idea is checking yours at freecreditscore.com.
.

__,_._,___

Tidak ada komentar:

Posting Komentar