select multiple rows from datasource table

[maswien]

I want select multiple rows of agent name from agents table from the form, I like check box rather than listbox, so I need a control to list all the agents name and each of them with checkbox, if I use unbound this seems not possible, but if I use bound, the original table will be updated when click the check box which is not allowed.

Any suggestion? Thanks

 

[lupins46]

You cannot do this without using a bound field.

 

[maswien]

The purpose to check or uncheck on these agents is just for determining what's the next action will be when the OK button is clicked on this form. But it will affect the value in the table of SQL Server, if many users use
the front end at the same time, there will be a mess, is it possible a form bounded to a temporary table?

 

[lupins46]

Yes that's what I do for my apps - I extract all relevant records into a 'work' table which is the same as the source but also has the 'select' field.

 

[maswien]

The problem is the work table won't be user specific, any bounded table will be used by multiple users and that cause problem.

 

[lupins46]

If you have multiple users you should be using a split database with each user having their own copy of the front-end. If you put the 'work' table in the front-end then this gets round the user-specific data issues.

 

[maswien]

Thanks lupins46, I think what you said should work, create a data sheet with checkbox and bind it to the local table, then the user can change the local table without affecting the SQL Server table.

I use access ADP, the backend is SQL Server. How can I split the database?