Directing the tab order based on selections

[DanEaton]

I have a little problem that I'm trying to work thru. I'm creating a catalog database and am incorporating the filing system within it. We have three formats of catalogs here: catalogs, cd's, and datasheets. Datasheets are narrow so we store them in binders. ANYWAY, I have the following in my main catalog data entry form

FORMAT: Catalog Binder: (COMBO BOX)
CD
Datasheet

The "FORMAT" object there is a listbox with three possible selections. The "Binder" object is a combo box that I would like to get the focus if datasheet is selected from the format menu. Can anyone suggest how I could direct users to the Binder combo box if (and only if) datasheet is highlighted. Otherwise, I would like them to proceed to other fields. Thanks
Dan Eaton
deaton@caemachinery.com

 

[TrojanRabbit]

Set the combobox up as disabled in the form. Also, put it immediately after the listbox in tab order. You can use FORMAT's BeforeUpdate event to enable the combobox if Datasheet is selected. I'm not sure if you need to check FORMAT using a string or number (FORMAT = "Datasheet" vs. FORMAT = 3). The listbox doesn't have an OnChange event, so I'm not sure if you can move to the combobox as soon as Datasheet is clicked. Combo boxes have an OnChange event that allows this.