Can you Make A drop down box without attaching to a Form?

[catbeasy]

version: Access 97


I was wanting to make a drop down box in code (called from code) without attaching it to a form. The drop down box would be bound to a table.

I was thinking that this might be able to be done much like you can write code to create an input box. The input box doesn't have to be attached to a form and so I thought maybe a drop down box doesn't either??

I am trying to avoid creating forms if I don't have to..

Thanks for any assistance..

 

[pbaldy]

To my knowledge there is no combo box equivalent to the VBA InputBox. I think you're going to have to create a form.

 

[MSAccessRookie]

version: Access 97


I was wanting to make a drop down box in code (called from code) without attaching it to a form. The drop down box would be bound to a table.

I was thinking that this might be able to be done much like you can write code to create an input box. The input box doesn't have to be attached to a form and so I thought maybe a drop down box doesn't either??

I am trying to avoid creating forms if I don't have to..

Thanks for any assistance..

The only Drop Down Boxes I have used are Combo Boxes or List Boxes, and I have used Both as Controls of Forms. There is no need to be afraid of forms, and we will assist you any way we can when you have questions. You can start by opening your favorite table and clicking the New Object Button (looks like a lightning Bolt on top of a form) to create a form that is based on your table.

 

[catbeasy]

The only Drop Down Boxes I have used are Combo Boxes or List Boxes, and I have used Both as Controls of Forms. There is no need to be afraid of forms, and we will assist you any way we can when you have questions. You can start by opening your favorite table and clicking the New Object Button (looks like a lightning Bolt on top of a form) to create a form that is based on your table.

Thanks, you don't need to fear that I have a fear of forms. I was trying to operate on the principle of ochams razor or not multiplying entities (or some form of that exhortation)..

 

[HiTechCoach]

Thanks, you don't need to fear that I have a fear of forms. I was trying to operate on the principle of ochams razor or not multiplying entities (or some form of that exhortation)..

It is possible to make a single form with a combo box reusable. I think this would do you what you want. I do this now. You can use a single form with a combo box or list ox that can be used to get a value from a passed lookup table name.

 

[catbeasy]

It is possible to make a single form with a combo box reusable. I think this would do you what you want. I do this now. You can use a single form with a combo box or list ox that can be used to get a value from a passed lookup table name.

Great idea! I'll try that..thanks..

 

[gemma-the-husky]

what do yuo want to do with this floating combo box?

what sort of thing are you selecting