Possible to change record source in multiuser environment?

  • Thread starter Thread starter krini_pop
  • Start date Start date
K

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
 
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.
 
Thanks Bill!



Bill said:
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.
Click to expand...
 
Back
Top