Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    4

    Unanswered: HELP - Combo/List Box Guru Required

    HI,

    I need a combo box or list box to look up the names of the Forms created.

    Normally List/Combo box normally shows a column form a particular table. But what I need is it to show a list of Form Names instead.

    Anyone know ?


    Nick (newbie)

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Code:
    Dim db As Object
    Dim frm As AccessObject
    
    Set db = Application.CurrentProject
    
    For Each frm In db.AllForms
        cboYourCombo.AddItem frm.Name
    Next frm
    Also note that the comboboxe's recordsource type needs to be set to "value list".

Posting Permissions

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