Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Houston, Texas, USA
    Thanked 0 Times in 0 Posts

    make Pull down list mandatory (Office 2003)

    In my form I have a pull down that will display the names of all the clients. The users select a name, and it is entered in the field. But, then I have a few lazy Uses that will enter any thing to save time on their part. This is the Code I use for the field

    'Retrieve Category info from table
    Set rst1 = db.OpenRecordset("Work4number")
    Set ctl = Item.GetInspector.ModifiedFormPages("Message").Con trols("cboClient")
    ctl.ColumnCount = 2
    ctl.ColumnWidths = "40; 20 pt"

    'Assign Access data to an array of 2 columns and 500 rows
    CategoryArray(99, 2) = rst1.GetRows(500)
    ctl.Column() = CategoryArray(99, 2)

    How can I make it so that they can only enter from the selected list and not type in a Client, even if the client name is correct?

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Vienna, Wien, Austria
    Thanked 0 Times in 0 Posts

    Re: make Pull down list mandatory (Office 2003)

    I haven't really looked at Outlook Forms in quite a while. In Access, however, there is a Limit To Lists property that can be set to Yes (aka True). From what you say, you might have already tried this. If not, Hope This Helps.

Posting Permissions

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