ACCESS FEED: Re: [MS_AccessPros] Cascading Combo Boxes Values in a Query

Selasa, 30 Agustus 2011

Re: [MS_AccessPros] Cascading Combo Boxes Values in a Query

ps...

just noticed you are using a reserved word...

do not use DATE as a name of any of your objects (fields, tables, aliases, etc), it is a reserved word

Problem names and reserved words in Access, by Allen Browne
http://www.allenbrowne.com/AppIssueBadWord.html

Warm Regards,
Crystal

*
(: have an awesome day :)
*

--- On Tue, 8/30/11, Crystal wrote:

> 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 wrote:
>

> > 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
> >
> >
> >
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
> MS_Access_Professionals-fullfeatured@yahoogroups.com
>
>
>