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