Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

absolute record value in combo box query

Status
Not open for further replies.
Feb 12, 2003
45
US
Is there a way to pull or reference the absolute record value from a query in a combo box?
Thanks,
Chris
 
the absolute position would match the combos index

or were you meaning abs()
 
I'm trying to reference the absolute record value of the selected item (the datasource being a query).

If you're saying the absolute record is the index, how would I reference that in code?
 
Hi Chris,

I also am a bit puzzled as to what you are trying to ascertain, but if you are trying to figure out where you are in a list box (as in the "row" number of the selected item), then use the following. Keep in mind that it is 0 based.

intPos = Me.YourListBox.ListIndex

Me.YourListBox.ListCount will give you the number of items in the list box.

Cheers,
Bill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top