How to determine record number in recordset.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I do NOT want to use a combo box.

The objective is to display records in a list box and then programmatically
select one (lst.selected(x)) based on contents of a text box.

eg the list box source is a query. The user enters a person's name in a text
box. I do a FindFirst on the same query and locate the record. If I knew it
was say record number 52 then I can easily highlight it in the list box.

I have heard there is no such thing as a record number concept in DAO.
 
ThomasAJ said:
I do NOT want to use a combo box.

The objective is to display records in a list box and then programmatically
select one (lst.selected(x)) based on contents of a text box.

eg the list box source is a query. The user enters a person's name in a text
box. I do a FindFirst on the same query and locate the record. If I knew it
was say record number 52 then I can easily highlight it in the list box.

I have heard there is no such thing as a record number concept in DAO.
Click to expand...


Recordsets have the AbsolutePosition property, which should
do what you asked for.

Note that if the value you are searching for is an exact
match for the list box's BoundColumn, you can select the row
by just setting the list box's Value to the name in the text
box.
 
Back
Top