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 derfloh 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. Schwiz

    Retrieve a row in a table in Access, and populate a form

    I was able to figure this out: Dim mySQL As String mySQL = "SELECT * FROM [File Information] " & _ "WHERE [File Information].[File ID] = " & fileID & ";" Me.RecordSource = mySQL Me.Requery
  2. Schwiz

    Retrieve a row in a table in Access, and populate a form

    When I remove its 'Control Source' and execute that line of code it says that "File_ID is not recognized as a field name or expression". But File_ID is the name of the drop down. :(
  3. Schwiz

    Retrieve a row in a table in Access, and populate a form

    @Skip, I'm sorry I'm still trying to get used to this forum and I did not see that section. @PHV, I did try that line of code. The form is bound to [File Information] but File_ID is also bound, therefore it did not work correctly. I got this error: Run-time error '3426': This action was...
  4. Schwiz

    Retrieve a row in a table in Access, and populate a form

    Hey everyone, I have a little bit of a dilemna. I have a form that I am using to enter/view specific file information. From a drop down menu the user can selection File_ID, and based on what the user selects I want to pull up the rest of the information in that table row where File_ID = the ID...

Part and Inventory Search

Back
Top