Beginner VBA question

Results 1 to 2 of 2

Thread: Beginner VBA question

  1. #1
    Join Date
    Dec 1969

    Default Beginner VBA question

    Hey everyone,<BR><BR>I have a simple form that sorts database enteries based on user input. I have three list boxes that right now pull data from a static SQL Statement. What I would really like to be able to do is allow the user to select a table for these input boxes to get their datafrom with a drop down box. I know it will require VBA coding I&#039;m just not sure how to get it started. <BR><BR>Any suggestions?

  2. #2
    Join Date
    Dec 1969

    Default RE: Beginner VBA question

    You need to use an OnChange event on the drop down box that you use to select the table. When it changes (when a new table is selected) you need to update the recordsource of the other drop down boxes

Posting Permissions

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