I have a table(Authors: AuthorID/autnumber,AuthorName/ text).
In some forms I need to populate all authors in Data List combo box ordered by authorname. I do that by;
dim AuthRS as Adodb.recordset
set AuthRS = new adodb.recordset
Authrs.Open "Select * From Authors Order By AuthorName", _
it works fine when the recordset cursor location is clientside, but the problem is my application is networkable and some workstation adding authors and the others use other forms that contains the desired combo box. if iam going to requery the recordset it will take a few seconds to repopulate the new data. Is there any way to keep my table dynamic to all users? if i use the serverside cursor location then the statement :
Set Combo1.RowSource = AuthRS
will not work.