Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Agency not present... (6.0)

    The project start with a selection in textbox(userform SELECTION)...
    In effect the code make a filter and show data into MODIFICHE userform...
    Now my prob is:
    If the user select and agency not present in the mdb the userform MODIFICHE is show without data...
    I would want before the userform MODIFICHE is show, to make appear a msgbox similar "NO AGENGY for code xxxxx" Where xxxx is the value inserted in textbox of SELECTION userform...

    note:change pat of mdb
    note: i have maked button with Sheridan ocx....

    here the project:http://www.mytempdir.com/886434

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

    Re: Agency not present... (6.0)

    Why don't you use a combo box that lets the user select only existing agencies?

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Agency not present... (6.0)

    Good idea, but agency peraph are 500 or 600 in official project...

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

    Re: Agency not present... (6.0)

    Users don't need to use the dropdown list, they can still type the agency, but if you set the Style of the combo box to 2 (vbComboDropDownList), the combo box will only accept items from the list.
    You can fill the list from a recordset when the form is opened.

Posting Permissions

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