Form opening with no Data RRS feed

  • Question

  • My form has the record source to a table, All the data is in my table. But when I open my form the data is not showing . It shows the last EmployeeID  number only, If I have 8 records it shows EmployeeID 9. This is the code to open my form............Thanks for any help........Bob

    Private Sub cmdEmployeeGo_Click()
    Dim stDocName As String
        Dim stLinkCriteria As String
        stDocName = "frmEmployeeInfo"
        stLinkCriteria = "[EmployeeID]=" & Me![EmployeeID]
        DoCmd.OpenForm stDocName, , , stLinkCriteria
    End Sub


    Sunday, July 9, 2017 12:14 AM


  • Thanks DB, It only shows last Blank table field..........Bob


    Okay, check to make sure the Data Entry property is set to No.
    • Marked as answer by TurnipOrange Sunday, July 9, 2017 1:02 AM
    Sunday, July 9, 2017 1:01 AM

All replies