You cannot have an unbound control that shows different values on different
rows of a continuous form.
The simplest workaround is therefore to add a yes/no field to the table.
This gives you a bound check box, and so the user can select records. You
can then Execute your append query in the UnLoad event of the form, and
reset the check boxes in the table with:
dbEngine(0)(0).Execute "UPDATE Table1 SET IsPicked = False WHERE
IsPicked = True;", dbFailOnError
But you say this is a multi-user environment, so that won't be adequate. You
probably want a related table in the front end to store the primary key
value of the records they selected. You can then base the form on a query
that uses this table with your original table, making sure you use an outer
join between the 2 tables. (Double-click the join line in query design.) You
have some kind of control (command button?) on the continuous form that
appends/deletes the record to/from the local table. Now each user can select
their own records independently of the others.
--
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.
"Steve B" <st******@co.lake.ca.us> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
I am trying to design a Call Log Detail form that will allow users, in
a multi-user environment, to select various data/records, not
necessarily in sequential order, from a subform that will, when the
parent form is closed, append the selected records to a historical
table. In this particular case, a multi-select list box will not work
because the users have requested the ability to view details or query
additional information about the individual records from the subforms,
hence, call another form to display. Does anybody have any idea on how
to get something like this to work?