Asking

[accessman2]

Hi,

In table,

dim db as database
dim rs as recordset
dim i as integer

set db = currentdb
set rs = db.openrecordset("Select * from [table1]")

for i = 1 to rs.recordcount
if rs.fields("Selected") = true then ' checked box
.....................
end if
next i

If I make the continuous form, the record source is table1.
I want the user check the box of the record if s/he want to use its record value to calculate the total. But, the selection will not update in the table. Because if multi users work at on that at the same time, then the results will be affected. So, I don't want the selection to update the table, the current selection only show in the current form.
How can I do it?

 

[Uncle Gizmo]

you could make a temporary local table of the data you require.