combo box on tabs (1 Viewer)

Danny · Jul 10, 2019

Greetings,

I'm supporting an a 2016 access db that was designed by someone else. The requirement is for me to add a new drop down field with in a tab in the form. The name of the tab is pgeFinancial and the drop down field I attempted to create is called disposition with items like guilty, not guilty etc.
When I drag drop down to the area I want the field to appear in pgeFinancial, the wizard doesn't appear. As a result, I can not enter the drop down items. Can you please advise what I'm doing wrong?

TIA

Regards,

June7 · Jul 10, 2019

I never rely on wizards. Install combobox on tab control page and manually set properties.

Danny · Jul 10, 2019

June 7, thanks!

can you please guide me on how this is done i.e manually set properties?

TIA

Regards,

theDBguy · Jul 10, 2019

Hi Danny. Did you check if it was turned on?

Danny · Jul 10, 2019

Hi the DBguy,
When I drag the drop down to a form, the wizard appears. But, when I drag it where I want it to be (on a tab), the wizard doesn't show. I take it's turned on.

TIA

Regards,

theDBguy · Jul 10, 2019

Danny said:
Hi the DBguy,
When I drag the drop down to a form, the wizard appears. But, when I drag it where I want it to be (on a tab), the wizard doesn't show. I take it's turned on.

TIA

Regards,

I'll have to check that out. But if you can use the Wizard when dragging on to the form, then do it like that for now. Once you're done, you can "cut and paste" it to the Tab control.

isladogs · Jul 10, 2019

You should never drag items onto a tabbed control as they will 'bleed through' and appear on each tab. Instead click the combo on the ribbon then draw out the shape on the tab to create it. I've checked and if you use wizards they will appear automatically when you do the above.

June7 · Jul 10, 2019

Have you not ever explored the Properties Sheet?

The wizard opened up for me when I placed combobox control on tab page.
1. click tab 2. click combobox 3. click on tab page

isladogs · Jul 10, 2019

June
Was your last reply directed at the OP or at me?
If at myself, then of course I use the Properties sheet

Your description of placing the combo was exactly the same method as mine but just using different words.

Danny · Jul 10, 2019

Hi,

Thank you for your feedback.

I actually did exactly what was suggested: I first clicked the tab where I want the drop down to appear, I clicked combo box and placed it in the tab, still the wizard didn’t appear.
I then used theDBguy’s suggestion: I created the combo box onto a form then cut and paste it to the tab control which seems to work. The only question I’ve is that how to associate this newly created field in my table. i.e. do I create my field ‘Disposition’ in the table first and in the wizard I select store the value in this field option, or do I select Remember the value for later use option?

TIA

Regards,

theDBguy · Jul 10, 2019

Danny said:
The only question I’ve is that how to associate this newly created field in my table. i.e. do I create my field ‘Disposition’ in the table first and in the wizard I select store the value in this field option, or do I select Remember the value for later use option?

Try selecting the field from the Wizard...

Danny · Jul 10, 2019

The field I created doesn’t show in the wizard. This is because I created the combo box in a form and cut/paste onto the tab control.

TIA

Regards,

theDBguy · Jul 10, 2019

Danny said:
The field I created doesn’t show in the wizard. This is because I created the combo box in a form and cut/paste onto the tab control.

TIA

Regards,

Hi. Sorry, that doesn't make sense to me. Is the main form bound or unbound? If unbound, what is in the tab page? A subform?

Danny · Jul 10, 2019

The main form is unbound. The tab page is a subform (frmFinancial). I tried creating the combo box onto frmFinancial, this time the wizard appeared. But, now the financial tab becomes blank.

TIA

Regard,

Danny · Jul 10, 2019

I created the combo box onto frmFinancial which is a subform. I was able to access the wizard when creating combo box. I verified the table is updating my test values, and everything seems to work fine now.
Thanks everyone for your feedback.

Regards,

theDBguy · Jul 10, 2019

Danny said:
I created the combo box onto frmFinancial which is a subform. I was able to access the wizard when creating combo box. I verified the table is updating my test values, and everything seems to work fine now.
Thanks everyone for your feedback.

Regards,

Hi. Glad to hear you got it sorted out. Good luck with your project. For future reference, you might want to examine all the properties of your new combo, so maybe in the future, you won't have to rely on the Wizard to create them. Cheers!

June7 · Jul 10, 2019

@isladogs, my previous comment was intended for OP in response to post 3. Notice that our posts were only 1 minute apart - I had not seen yours.

isladogs · Jul 10, 2019

Thanks June. Forgot to look at the post times.

Danny · Jul 10, 2019

Many thanks everyone!

Regards,

combo box on tabs (1 Viewer)

Registered User.

AWF VIP

Registered User.

I’m here to help

Attachments

Registered User.

I’m here to help

MVP / VIP

AWF VIP

MVP / VIP

Registered User.

I’m here to help

Registered User.

I’m here to help

Registered User.

Registered User.

I’m here to help

AWF VIP

MVP / VIP

Registered User.

Similar threads

Users who are viewing this thread