So the list box is being used to filter the records that need to be edited?
You could use the code in the link to OpenForm with a WhereCondition so that
it contains only the records to be edited. The user then edits the record,
steps to the next one (using the built-in navigation buttons), and so on,
going back if needed, until the selected records are done, and then closes
the form.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"doncee" <no*****************@charter.net> wrote in message
news:Xn*************************@216.196.97.131...
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in
news:44435939$0$16685$5a62ac22@per-qv1-newsreader-
01.iinet.net.au:
http://allenbrowne.com/ser-50.html
Thanks for your reply and the example\sample. Am trying to open
several records of a table via a specific form by highliting
those records in a list box. When the record has been updated &
then form closed the next highlited record would open in the
same form for editing until each of the highlited records have
been updated. Hopefully this makes sense. This is actually
similiar to the Developers Sample Phone list that is shipped
with Access but I felt that example was pretty cheesy & was
difficult to follow the code.Thanks for any help you can offer.
dc