Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007

    Question Unanswered: Form Dataentry Property and Serarch Question

    I have a form and I use a code as follows with an unbound textbox to search. When I sent the dataentry property to yes it does not work. When I set the property to no the code works. I have the same exact code on other forms with the dataentry property set to yes and it works correctly. What am I missing?

    If Not IsNull(Me!FSSS) Then
    Me.RecordSource = "Select * from [Rate Table] where [Account Number] = '" & Forms![Rate Data]!FSSS & "'"

  2. #2
    Join Date
    Apr 2014
    Provided Answers: 23
    data entry should have no affect either way.
    have you tried just filtering? set the form to show all records,
    then the afterupdate event:
    sub FSSS_afterupdate()
        If IsNull(FSSS) Then
            me.filterOn = false
            me.filter = "[Account Number]='" & me.FSSS & "'"
            me.filterOn = true
    end sub

  3. #3
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Actually, it odes! DataEntry set to Yes only allows New Records to be existing Records in the Form's RecordSet are displayed...hence your problem.

    Why, exactly, do you have DataEntry set to Yes, if you want to view existing Records? Despite its name, it doesn't have to be set to Yes in order for data to be entered.

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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