Hi
I hope you bare with me on this - I want to highlight a record in a
subform, whose data is based on a query. I.e. I want the marker to
jump to the record that has the field [PersonID] = 23235 for instance.
I've tried several solutions I found when searching the forum, but
none worked. I have a main form, containing a text box where I enter
the search criteria (fakinput). My code is this:
1. Me.Sub.SetFocus
2. DoCmd.GoToContr ol "PersonID"
3. DoCmd.FindRecor d fakinput, acEntire, , acSearchAll, , acCurrent
It stops at line 2 here, it tells me it can't jump to the control. I'm
a bit of a newbie at access.
using Access 2003.
I hope you bare with me on this - I want to highlight a record in a
subform, whose data is based on a query. I.e. I want the marker to
jump to the record that has the field [PersonID] = 23235 for instance.
I've tried several solutions I found when searching the forum, but
none worked. I have a main form, containing a text box where I enter
the search criteria (fakinput). My code is this:
1. Me.Sub.SetFocus
2. DoCmd.GoToContr ol "PersonID"
3. DoCmd.FindRecor d fakinput, acEntire, , acSearchAll, , acCurrent
It stops at line 2 here, it tells me it can't jump to the control. I'm
a bit of a newbie at access.
using Access 2003.