Continuous form with different rowsource in same combobox

[linux_s2002]

Hi, in my db can I add a combo box (see "parameters") to the continuous form and change its value depending on the field Category?

Thanks!!

 

[theDBguy]

You can; but in a continuous form, it would reflect on all rows. Does it have to be a continuous form? This is not a problem in a single view form and also not a problem if the continuous form is read only. But if you want the user to see the dropdown, it gets tricky.

 

[MajP]

There are a couple tricks to do "cascading combos" in a continous form. Here is an example of the way I do it and a discussion of the other method.

Cascade combobox on continuous form

Hi all, I would like add a cascade combo box to my subfom, but it's in continuous form and I have always error about parameter. It works on second combobox ("ValoriCarrieraIDcmb"), only if I put manually the number of ElencoCarrieraID, for example "8". How can I filter it? Thank you very much

www.access-programmers.co.uk

Semi Unique Combox Record Source on Continuous Form

Take a look at the demo on the right. This uses the trick of overlaying a textbox on the combobox. This gets rid of fields going blank. In the current format if you key down it goes blank as well as the scroll

www.access-programmers.co.uk

enabling cascading comboboxes in datasheet or continuous form

Having been asked about this recently, I reinvented some code I developed to work with datasheets and which also works with continuous and single forms. The attachment was developed in 2010 but saved as 2003. The db demonstrated two techniques for using cascading comboboxes. Technique 1 is...

www.access-programmers.co.uk

I use the trick with a combobox over top of a textbox vs @CJ_London method for several reasons. Although it can work most of the time I still get cases when I either get a flicker or things go blank in the record that has focus. Somewhere I have a demo showing both and some problems I have encountered when changing the rowsource on entry and exit.

 

[mike60smart]

Hi, in my db can I add a combo box (see "parameters") to the continuous form and change its value depending on the field Category?

Thanks!!

You should not be using Lookup fields in Tables