New record in subform positioning dilemma

[rttrent]

My main form has a textbox with an after-update event which inserts its value into a table. It then performs a requery on a subform of the main form which brings the newly added record into the subform whose record source is a sql query.
My dilemma: The new record is indeed added to the table and the continuous form. I expected the continuous form to display the first record of the query but the current record is not affected and the display of the form would only be displaced by one record if the added record preceded it in sort order. I wish the continuous form to display the newly added record as the active selection but I've had no success as yet. Perhaps the requery not changing the current record is related. I sure would appreciate any advice anyone can offer. I'm rather new at Access but I'm enjoying learning. I'm running Access 2007 under Windows 8.

[orange]

There are some free video tutorials about subforms at
http://www.datapigtechnologies.com/AccessMain.htm

[rttrent]

Thanks orange! That site really helped. I found 1) typos, 2) referencing problem and 3) learned about bookmarks. It's working now as hoped and I appreciate your info. )

[rttrent]

Thanks orange! I had three major bugs in my code and your reference pointed them out to me. The app is now working as designed and I appreciate your help. I'd mark this 'solved' if knew how! )

[orange]

Glad to help, and I see it has been marked Solved.