Possible to change record source in multiuser environment?

[krini_pop]

Hello,
Is it possible to change the record source of a subform in a multiuser
environment? Would this cause issues? Should I split the database so
each user could have their own set of forms? The subform is set up for
continuous forms. There is a combo box that allows you to select a
category and based on the category you select, the records you can
select from are filtered. The record source is changed on the after
update event for the combo box. Any help and/or suggestions would be
appreciated.

Thanks
Trina

 

[Bill Mosca]

There shouldn't be any problems changing the recordsource, because each user
gets his own instance of the forms/reports, and when a recordsource is
changed programmically, the change is only temporary unless it is saved in
design view.

But the real issu here is a multi-user database to begin with. The database
should be split and each user should have his own local copy of the front end.

 

[krini_pop]

Thanks Bill!

There shouldn't be any problems changing the recordsource, because each user
gets his own instance of the forms/reports, and when a recordsource is
changed programmically, the change is only temporary unless it is saved in
design view.

But the real issu here is a multi-user database to begin with. The database
should be split and each user should have his own local copy of the front end.