code to move combo to next/previous value on unbound form

[Happy YN]

I have a combo on an unbound form based on a sql. When user selects combo , all textboxes are updated.
What code can I put behind command buttons that will move the combo value to the next/previous record. There are no sequential numbers in sql list (unless I should put them into sql & use those??)
Also although form updates textboxes if combo is changed manually, I find that if combos value is changed programatically then the onchange event does not occur so how can I force it?
Thanks!

 

[directormac]

pro'ly wrong...

I'm sure I'm not understanding correctly, Happy, but let me ask if you are using SQL to open a recordset or just the displayed record? If the SQL statement is, say, part of the .Open method for your recordset, can't you then use the "move" methods (i.e., .MoveNext) on the same recordset object?

I'm sure I'm wrong, but I can't wait to learn from my mistake...

--Zen Mac

the grasshopper rights himself...

Ah, you're talking about moving to the next or last item in the list contained within a control... NOW me understand.

<baboon-like> "I are being Access guy! I are being Access guy!"

Well, dang...

I.R. Mac