General discussion

Locked

Create Access 2000 Combo Box via VBA Mod

By CUZZ ·
I would like to use a VBA module to create my combo box on a form. I would like to base the value list of that combo box on the contents of another control. For example, if Control "X" = "Biological" then the combo box should contain a list of items pertaining to Biology. Otherwise, if Control "X" contains the word "Physical", the combo box would provide a different list. How can I do that?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by john_wills In reply to Create Access 2000 Combo ...

select case me.BoxAlreadyFilledIn
case "Physics"
me.BoxToDefine.RowSource="SELECT Thing FROM PhysicsTable;"
case "Metaphysics"
me.BoxToDefine.RowSource="SELECT Res FROM MetaphysicsTable;"
case "Art"
me.BoxToDefine.RowSource="SELECT objet FROM ArtTAble;"....etc.

Collapse -

by CUZZ In reply to

Works perfectly! Thank you!

Collapse -

by CUZZ In reply to Create Access 2000 Combo ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums