Printable View
1 .i have an ADO box connecting to a list table, and a txt box which the ado
operns into.
2. a combo box listing 1 - 10
all im looking for is if you select 1 in the cbo box then the ado will keep the first record it operns on to, if you select 2 in the combo box the ado will go to the second record in the table if you click 3 it moves to the 3rd entry in the table
so CBO box - 1 - 10
text box showing the table date via using the ado which works.
Do the records have a numbering system so your program would know which record was actually number 3?
Also, what do you mean by "keep"? Do you mean display?
i mean display, sorry,
when i f5 the program it shows the first record in the table on the database, when you click on the arrow for the next record it automaticly has it in order, so just really need the code to be the clicking of that arrow on the ado, if you know what i mean
Those arrows proceed sequentially.
You are selecting a piece of information from a combo box which does not exist in the database, i.e., a record number.
I suppose you could create a recordset with a SELECT * query, and try using rs.MoveFirst, rs.MoveNext, rs.MovePrevious
Is this a program requirement or more a curiousity question?
its not a program requirement its just a thing ive wanted to get working lol,
woudl the code go like :
if cboBOX1 = "Sample" then
adoBOX1.recordset.movenext
?? ??
Is there a reason that you decided to stick with the Evil data control, even though I gave you the full code to replace it (in this thread)?