Results 1 to 4 of 4
  1. #1
    DubCap01 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2014
    Location
    Dubbo, Australia
    Posts
    104

    Field Change to requery/refresh subform!

    Hi all and a happy new Year



    I have a form, one field [EventID] and one Subform (FrmSubCompletion2, with fields [EventID] and [Surname]), all of which are unbound.

    There is a table involved, [TblFlow] which stores all the relevant data.

    What I have been trying to do unsuccessfully is to update the subform fields to (using the keyed input from the unbound field [EventID])

    a: Display the [EventID] in the subform field [EventID]
    b: Dlookup and display the corresponding Surname from [TblFlow] in the [surname] field
    c: Refresh every time a key is pressed!

    So, in a scenario of 12000 records, if I type 12 - I like to get 12, everything 120 onwards, and everything 1200 onwards!

    that is until I get to a point where I am trying to find "11979', and on the fourth keypress (1197....) it shows me eleven records (1197 and everything in the 1197* range)

    I cannot seem to get the VBA to requery the subform using either OnKeyPress or OnChange events.

    Any clues anyone?

    cheers in anticipation
    Pete

  2. #2
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    What is the VBA you are using to requery the subform in the On Change event?

    Is the subform have a table/query as a recordsource?

  3. #3
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    I am going to only point out that the standard combobox control inherently has the jump-to-entry as one types/enters each individual character. The listbox probably does too - not 100% on that one as I don't use them nearly as frequently.

  4. #4
    DubCap01 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2014
    Location
    Dubbo, Australia
    Posts
    104
    thanks to all that responded, I opted for a sub-form with an action command button linked to each continuous form record...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 07-17-2013, 01:11 PM
  2. Refresh / Requry Subform Upon Combobox Change
    By michael.legge@rbc.com in forum Access
    Replies: 3
    Last Post: 06-18-2013, 06:28 AM
  3. Replies: 11
    Last Post: 09-17-2012, 02:23 PM
  4. Requery vs. Refresh
    By tylerg11 in forum Forms
    Replies: 3
    Last Post: 03-28-2012, 11:54 AM
  5. Refresh Requery Subform
    By eww in forum Programming
    Replies: 1
    Last Post: 04-05-2011, 09:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums