Cascading combo on continuous forms

[Guest]

Hi

I use the she standard method (work-a-round) for using cascading combo boxes
on a continuous form. Placing a bound text box over the combo (except for
the dropdown arrow) and then set the value of the text box from the combo
selection.

There has to be a better way than this. Has anyone got one.

If you use
Forms![MainFormName]![SubformName].Form![SubFormControl].Requery to set the
value of the next box in cassced this will requery the control in all records
and mess up the other records. Whoever made access MUST have realised this.

There are so many times when developers will need this process to make users
work easier.

On one DB of mine I have a main form showing the amount banked and a subform
(continuous) showing the departments and the items.

Something like
Main form
PaymentID – Debit/Credit – Amount Banked – Date

Subform
ItemID – Department (AfterUpdate – set values of Items combo)
Items - (AfterUpdate – set values of another combo)
Etc (eg. Tax payable – can be done manually but better to cascade as some
items are non-taxable, etc)
Etc

Does anyone have a fix for cascade combos on a continuous sub form.

 

[Guest]

Is there a reason why the first combo has to be in the main form?


--
http://www.patriotsquestion911.com
http://www.911truth.org
http://www.wtc7.net
http://www.st911.org
http://www.journalof911studies.com
http://www.pilotsfor911truth.org
http://ae911truth.org

 

[Guest]

Hi

It isn't.

The main form (in this case) what be
PaymentID
Amount
Date
Credit/Debit
All of these are bound textboxes.

The subform has a number of casscading combos that relate to this PaymentID.

I know you can cover the combos with bound textboxes or even simple have a
single form with combos and then have a 2nd subform with a continous form
(placed so it looks like it part of the main subform.

I know it "can" be made to look like it all work (and in a way it does). I
am just looking to see if there is anyway to casscade combos on a continous
form with any work-a-rounds.

Maybe it can't be done as on a continous form there is only one recordset
(the one with the focus) .

Worth asking though.

--
Wayne
Manchester, England.

Is there a reason why the first combo has to be in the main form?


--
http://www.patriotsquestion911.com
http://www.911truth.org
http://www.wtc7.net
http://www.st911.org
http://www.journalof911studies.com
http://www.pilotsfor911truth.org
http://ae911truth.org

Hi

I use the she standard method (work-a-round) for using cascading combo boxes
on a continuous form. Placing a bound text box over the combo (except for
the dropdown arrow) and then set the value of the text box from the combo
selection.

There has to be a better way than this. Has anyone got one.

If you use
Forms![MainFormName]![SubformName].Form![SubFormControl].Requery to set the
value of the next box in cassced this will requery the control in all records
and mess up the other records. Whoever made access MUST have realised this.

There are so many times when developers will need this process to make users
work easier.

On one DB of mine I have a main form showing the amount banked and a subform
(continuous) showing the departments and the items.

Something like
Main form
PaymentID – Debit/Credit – Amount Banked – Date

Subform
ItemID – Department (AfterUpdate – set values of Items combo)
Items - (AfterUpdate – set values of another combo)
Etc (eg. Tax payable – can be done manually but better to cascade as some
items are non-taxable, etc)
Etc

Does anyone have a fix for cascade combos on a continuous sub form.

 

[Roger Carlson]

I'd no idea that was the "standard" way.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "CascadingComboInSubform2k.mdb" which illustrates another
method. The file name is something of a misnomer because the sample is
really a Cascading Combo in a Continuous Subform.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Roger thats brilliant.

You're my hero. When I grow up I'm going to be you.

LoL ;-)

--
Wayne
Manchester, England.

I'd no idea that was the "standard" way.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "CascadingComboInSubform2k.mdb" which illustrates another
method. The file name is something of a misnomer because the sample is
really a Cascading Combo in a Continuous Subform.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Hi

I use the she standard method (work-a-round) for using cascading combo
boxes
on a continuous form. Placing a bound text box over the combo (except for
the dropdown arrow) and then set the value of the text box from the combo
selection.

There has to be a better way than this. Has anyone got one.

If you use
Forms![MainFormName]![SubformName].Form![SubFormControl].Requery to set
the
value of the next box in cassced this will requery the control in all
records
and mess up the other records. Whoever made access MUST have realised
this.

There are so many times when developers will need this process to make
users
work easier.

On one DB of mine I have a main form showing the amount banked and a
subform
(continuous) showing the departments and the items.

Something like
Main form
PaymentID - Debit/Credit - Amount Banked - Date

Subform
ItemID - Department (AfterUpdate - set values of Items combo)
Items - (AfterUpdate - set values of another combo)
Etc (eg. Tax payable - can be done manually but better to cascade as some
items are non-taxable, etc)
Etc

Does anyone have a fix for cascade combos on a continuous sub form.

 

[Roger Carlson]

Hmmmm. You'd better wait until I grow up first.

--
--Roger Carlson
MS Access MVP
www.rogersaccesslibrary.com

Roger thats brilliant.

You're my hero. When I grow up I'm going to be you.

LoL ;-)

--
Wayne
Manchester, England.

I'd no idea that was the "standard" way.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "CascadingComboInSubform2k.mdb" which illustrates another
method. The file name is something of a misnomer because the sample is
really a Cascading Combo in a Continuous Subform.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Hi

I use the she standard method (work-a-round) for using cascading combo
boxes
on a continuous form. Placing a bound text box over the combo (except
for
the dropdown arrow) and then set the value of the text box from the
combo
selection.

There has to be a better way than this. Has anyone got one.

If you use
Forms![MainFormName]![SubformName].Form![SubFormControl].Requery to
set
the
value of the next box in cassced this will requery the control in all
records
and mess up the other records. Whoever made access MUST have realised
this.

There are so many times when developers will need this process to make
users
work easier.

On one DB of mine I have a main form showing the amount banked and a
subform
(continuous) showing the departments and the items.

Something like
Main form
PaymentID - Debit/Credit - Amount Banked - Date

Subform
ItemID - Department (AfterUpdate - set values of Items combo)
Items - (AfterUpdate - set values of another combo)
Etc (eg. Tax payable - can be done manually but better to cascade as
some
items are non-taxable, etc)
Etc

Does anyone have a fix for cascade combos on a continuous sub form.