Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cascading Combo Box Demo Question? (A2k (9.0.3821) SR-1 )

    Cascading Combo Box Demo Question?

    A2k (9.0.3821) SR-1

    See attached Cascading Combo Box Demo.

    How would I add a forth combo box (Table to Use) that the operator would use first at form open time to select either tblDemo or tblDemo2 to work with? Both tables have the same format.

    Table to Use
    Row Field
    Column Field
    Numeric Field

    Once the table is selected, the frmForm and sfrmForm record source would have to be changed so the Row, Columbo and Numeric combo boxes would would as normal.

    What code would I need to change the record source of both forms as described above?

    Thanks, John
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cascading Combo Box Demo Question? (A2k (9.0.3821) SR-1 )

    Hello John,

    The attached zipped database has an extra combo box for selecting a source table.
    If you look at the code behind the main form, you will see how this combo box is used.

    Regards,
    Hans
    Attached Files Attached Files

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cascading Combo Box Demo Question? (A2k (9.0.3821) SR-1 )

    Hi Hans

    Woks great, this was my missing link.

    With the help of yourself, Charlotte, Francois I know have 2 resuable forms (driven by variables) for my many lookup tables.

    Thanks, John

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •