Hi Terry,
in addition to the data being in the query, make sure the link fields are ON the child form -- Visible can be False so they don't show.
also, if the query gathers the data -- you may need to wrap the reference in a conversion function such as CLng to convert to Long Integer (even if it is in the underlying table). On second thought, data in unbound controls may be coming through as text... bottom line is that the data types have to match.
on the AfterUpdate event of the controls feeding LinkMasterFields -->
Me.subform_ControlName.Requery
Warm Regards,
Crystal
*
(: have an awesome day :)
*
--- On Tue, 8/30/11, Terry Olsen <terryomsn@msn.com> wrote:
> From: Terry Olsen <terryomsn@msn.com>
> Subject: [MS_AccessPros] Cascading Combo Boxes Values in a Query
> To: MS_Access_Professionals@yahoogroups.com
> Date: Tuesday, August 30, 2011, 11:31 AM
> 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
>
>
>
Tidak ada komentar:
Posting Komentar