Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Oct 2008
    Location
    London
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    combo box (2003)

    I have a 4 comboboxes on a form and I need to make sure that an entry is acvtually made from each box before the user moves on to the next form
    I have tried the
    If combobox.value = "" then
    combobox.setfocus
    end if

    Full code of form in attached

    but this achieves nothing at all

    suggestions please
    Attached Files Attached Files

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

    Re: combo box (2003)

    Try inserting a line

    Exit Sub

    below each of the lines with SetFocus.

  3. #3
    Lounger
    Join Date
    Oct 2008
    Location
    London
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: combo box (2003)

    Thanks Hans
    You will be pleased to know that I got the 9000 lines of code to work in the end and am now inserting error coding for it all
    Many thaks for you help in this it really was appreciated
    John

Posting Permissions

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