locked
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


    xxx



    Sunday, July 9, 2017 12:14 AM

Answers

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

    xxx


    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

  • This is my Properties sheet...........Thanks Bob


    xxx

    Sunday, July 9, 2017 12:22 AM
  • Do you see any records if you open the form manually from the nav pane?
    Sunday, July 9, 2017 12:22 AM
  • Thanks DB, It only shows last Blank table field..........Bob

    xxx

    Sunday, July 9, 2017 12:33 AM
  • Thanks DB, It only shows last Blank table field..........Bob

    xxx


    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
  • Thanks DB why would That have been set to yes :/  Regards Bob

    xxx

    Sunday, July 9, 2017 1:03 AM
  • Hi,

    Glad to hear you got it sorted out. Cheers!

    Sunday, July 9, 2017 1:08 AM
  • I copied the form from my ClientInfo to make a EmployeeInfo and ClientInfo has a Data Entry set to NO and works fine, Should I be changing that form as well?...............Thanks Bob

    xxx

    Sunday, July 9, 2017 1:11 AM
  • If you want a data entry only form, you want to set it to Yes; otherwise, to see and edit existing records, you want to set it to No.
    Sunday, July 9, 2017 1:52 AM