Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003

    Unanswered: Problem with logic - help!

    I have a form that adds a record after clicking an add button..

    There are two tables, a customer and an order form.
    Before an order can be placed, there has to be a customer in the customer table..

    I am trying to automatically fill in the customer information when a customer name is entered, this feature works. however when I do this for a {unique} customer number, it always selects the first record of the order table.

    Here is some of the code from the cust_id:

    Private Sub Combo401_AfterUpdate()
    ' Find the record that matches the control.
    Dim rs As Object

    Set rs = Me.Recordset.Clone
    rs.FindFirst "[Cust ID] = " & Str(Me![Combo401])
    Me.Bookmark = rs.Bookmark
    End Sub

    How can I correct this??

  2. #2
    Join Date
    Nov 2003
    Try using MoveFirst and MoveLast.

  3. #3
    Join Date
    Nov 2003
    Thanks but I am fairly new to this, can you give me an example?

Posting Permissions

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