Sorting while entering data

Thanks in advance for any assistance. I've read all the posts and still need
help.

I've probably explained more than necessary to frame my total issue:
TableA contains Field1, 2 and 3 (Y/N field).
QueryA appends Field1 and Field2 where Field3=Yes to empty temp TableB.
TableB Field1 is a lookup field bound to TableA Field1 (data-entry control).
FormB's recordsource is TableB.
User opens FormB (continuous view), edits existing and enters new records.
User can duplicate existing record to expedite entry using command button.

Issue 1:
Records appear in order entered (TableB order). How can I
update/refresh/etc. data after new record entered so that all records now
appear sorted in Field1, without use having to sort each time?

Issue 2:
When user clicks Duplicate Record command button, new record added at bottom
of form, but user must scroll to bottom of continous form to see this new
record that now has focus (I think). How can user duplicate record with
command button, sort be performed to position records in sorted order, and
user see new record without having to scroll (find) it?

Many thanks,

On Fri, 4 Jan 2008 21:10:01 -0800, BamaTaylor
wrote:

Issue 1:
Records appear in order entered (TableB order). How can I
update/refresh/etc. data after new record entered so that all records now
appear sorted in Field1, without use having to sort each time?

A table HAS NO ORDER.

Rather than basing your form on the Table, base it on a Query sorted by
Field1.

Issue 2:
When user clicks Duplicate Record command button, new record added at bottom
of form, but user must scroll to bottom of continous form to see this new
record that now has focus (I think). How can user duplicate record with
command button, sort be performed to position records in sorted order, and
user see new record without having to scroll (find) it?

Only by using code to add the record to the table, and then requery the form
and navigate again to the selected record.

John W. Vinson [MVP]