Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ccjmcd

    List box and data validation issue

    Thank you Remou that works perfectly.
  2. ccjmcd

    List box and data validation issue

    The problem I encounter now is that I can't use the list box to select any records. The other issue is when I find an error I do want to direct the cursor to the field in error.
  3. ccjmcd

    List box and data validation issue

    Thank you Remou for your reply. I tried the code and receive the following error: Run-time error '2108' You must save the field before you execute the GoToControl action, the GoToControl method, or the SetFocus method.
  4. ccjmcd

    List box and data validation issue

    The List box is unbound and the code is this: Private Sub List61_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[MachineID] = '" & Me![List61] & "'" If Not rs.EOF Then Me.Bookmark = rs.Bookmark End Sub...
  5. ccjmcd

    List box and data validation issue

    I am new, so I apologize in advance. I have a form that uses a list box for record selection. Once the form is modified I check data for validity using a macro in the AfterUpdate section of the form. The problem I have is the macro fires and checks the data and if invalid displays my message...

Part and Inventory Search

Back
Top