Re: Cascading Combo problem.


I stumbled on to a poorly documented method for using a cascading combo
boxes in Access. If you define your row sources as Stored Procedures,
the second one taking a parameter for the casqued. If you name the
first control the same as the parameter on the stored procedure it will
automatically use the value of that control. Then the only code you
need to make a well rounded robust set of cascading Combo Boxes is a
requery on the on enter event of the second box.

This allowed me to take gads of goofy code that tried to manage
different usage scenarios. It works well. This is barley mentioned on
the help for row source on the combo box control.


--
chakatheapemanPosted from http://www.pcreview.co.uk/ newsgroup access

.

Relevant Pages

  • Re: Cascading Combo problem.
    ... >I stumbled on to a poorly documented method for using a cascading combo ... >boxes in Access. ... If you define your row sources as Stored Procedures, ...
    (microsoft.public.access.formscoding)
  • RE: Is it possible
    ... I have 3 cascading combo boxes. ... The main form is based on the RF Table and the subform is based on ... There could be many more RFQ# 1a's, but he might not select them this time. ...
    (microsoft.public.access.forms)
  • Re: Creating Forms with dependent lookup fields (controls)
    ... As of yet I still have no relationships defined in this database and I’m ... "Keith Wilby" wrote: ... able to add cascading combo boxes etc. ... created the control boxes access assigns would already cascade. ...
    (microsoft.public.access.forms)
  • Re: Creating Forms with dependent lookup fields (controls)
    ... created the control boxes access assigns would already cascade. ... If you use the form wizard then, yes, it will bind your form to a data source, be it a table or query. ... Access has a steep learning curve and cascading combo boxes is quite an advanced topic. ...
    (microsoft.public.access.forms)
  • Re: Cascading Combo problem.
    ... This is needed because the requery causes the combo box to ... >>>I stumbled on to a poorly documented method for using a cascading combo ... If you define your row sources as Stored Procedures, ... >>>automatically use the value of that control. ...
    (microsoft.public.access.formscoding)