soso28
asked on
my 1'st Q for Experts Only
Dear experts;
I have a table(Authors: AuthorID/autnumber,AuthorN ame/ 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", _
myConn,,adCmdText
set Combo1.RowSource=AuthRS
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.
many thanks,
I have a table(Authors: AuthorID/autnumber,AuthorN
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", _
myConn,,adCmdText
set Combo1.RowSource=AuthRS
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.
many thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Comment from expert accepted as answer
Computer101
E-E Moderator
Computer101
E-E Moderator
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:
Accept emoreau's comment(s) as an answer.
soso28, if you think your question was not answered at all or if you need help, you can simply post a new comment here. Community Support moderators will follow up.
==========
DanRollins -- EE database cleanup volunteer