Combo Box/Form Problem

[Stemdriller]

When one of my forms opens, the user has 4 options via a combo box. If they select HV for example the form then opens up the relevant form linked with HV.

My problem is, the next time they open the form I am trying to get Access to default to the Form already selected eg HV.

Presently if the user goes back to the main screen they are presented again with the four options only when they select HV will the data come. They can only select one of the four options.

Any suggestions?
Thanks
Gareth

 

[vbaInet]

There's a Default Value property of the combo box. Use that.

 

[jzwp22]

My problem is, the next time they open the form I am trying to get Access to default to the Form already selected eg HV.

When you say "next time", do you mean the next time they login to the database? If so, then you must store the combo box choice for each user in a table related to the user. If you mean at some time during the same session then just don't close the form where the combo box is located. You can change the visible property to no, but of course you will have to make it visible again at some other event.

 

[missinglinq]

Also note that if your selection from the combobox is utilizing some event of the combobox (AfterUpdate is usually used) to trigger the opening of the form, the form won't be opened on returning to the combobox' form, because these events are only triggered when data is from the cbo is physically selected, not when it's populated by code. You'd have to have a separate button to click to trigger opening the form, so why not simply make the selection again?

Linq ;0)>