Re: Filtering a Number of Comboboxes Before Their Forms are Opened(?)

Hi -

To do what you are asking requires that the forms be opened in design view,
the combo box sources changed to match the office, and the updated forms
saved. While this can be done programmatically in VBA, it can be a pain.
Much easier would be to set and keep the "Office" value in a table, as
Marshall has suggested, then set the combo box sources in the form On Open
events to suit each office's requirements.

John




croy wrote:
I'm trying to set up a "switch" in my db such that another
office can get an updated front-end from me, and the first
time they open the mdb, they can select their office,
causing several cbos on various forms to change their
rowsource (or change a criteria in their SQL) so that they
don't have to weed thru so many choices.

I've got a startup form with a cbo for selecting their
office, and I've made it sticky, like it should be. But
now, how to change what they see in the cbos on the other
forms?


--
John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200802/1

.