Combo Box Data Sources RRS feed

  • Question

  • I'm not sure if this is the right place to ask this question but I think I'm using Visual Basic to do this so I guess I'll ask here. Pardon me if I'm incorrect.

    In Microsoft Access, I'm building a form with 2 fields, Type, and Name. Both fields are drop down combo boxes, but the name field is dependent on the type field.

    I'm trying to design my form so that when the user picks a type from the drop down, the name field drop down is populated with one query, "people", and when they choose the other type, the name field drop down is populated with a different query, "Contract".

    I've tried doing this in the expression builder without any luck so I thought I'd go hunting around.

    If you can help in any way, please post back.

    Friday, October 26, 2007 8:54 PM