Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2013

    Unanswered: Setting up Search Form across mutiple tables

    I am currently interning at a large corporation and was put in charge of creating a database to collect success stories on a global scale. I am faimilar with access but am having trouble sorting out this one area. I currently have 3 tables all with the same Field Titles. The only difference is that the primary key in 1 of the tables is set to autonumber due to that is the table linked to a user submission form, the others are text because they are static and only updated by myself. I have created a search form based upon the Reference ID field, and cannont get the fields within the form to sync with the other tables. Any help would be great! Here is the code I have used for my search button:

    Private Sub SearchB_Click()
    If IsNull(Search) = False Then
    Me.Recordset.FindFirst "[Reference ID]=" & Search
    Me!Search = Null
    If Me.Recordset.NoMatch Then
    MsgBox "No record found", vbOKOnly + vbInformation, "Sorry"
    Me!Search = Null
    End If
    End If

    End Sub



  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    read up on normalisation
    what you have there sound like a non normalised design
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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