Results 1 to 1 of 1
  1. #1
    Join Date
    May 2012

    Newbie Help pls: Cascading multiple Combobox from different tables

    Hello there everyone. Hope you can help me.

    I am new to this forum and have little knowledge on Database programming. I am trying to cascade multiple combox box from different tables and populate it to a text box to be saved to a table but i am unable to populate and save them. I have searched the forum but unable to get it.

    Basically I have 5 tables:

    tblL1 - level 1 account
    tbL2 - level 2 account
    tblL3 - level 3 account

    What I am doing so far:

    1) in a form, I will select a supplier code and that will populate the description. the description will then be saved to the Supplier name in the tblpayment.

    2) on the same form, I will select from the combo box Level 1, 2 or 3 and I want the description to populate either for Level 2 or level 3 (if the Level 3 is blank/Null). the description will also be saved to the field in the tblpayment.

    I am attaching a screenshot of what I have been doing.

    Hope to hear from your guys. Thanks a lot in advance.
    Attached Thumbnails Attached Thumbnails payment sheet.JPG  

Posting Permissions

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