Field Change to requery/refresh subform!

[DubCap01]

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

[John_G]

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?

[NTC]

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.

[DubCap01]

thanks to all that responded, I opted for a sub-form with an action command button linked to each continuous form record...