Re: How to determine record number in recordset.
- From: Marshall Barton <marshbarton@xxxxxxxxxx>
- Date: Tue, 07 Mar 2006 05:01:39 -0600
ThomasAJ wrote:
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.
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.
--
Marsh
MVP [MS Access]
.
- Prev by Date: Output of report, Send To email receipient gives an registry error.
- Next by Date: Re: alt gr does not work in remote desktop fullscreen
- Previous by thread: Output of report, Send To email receipient gives an registry error.
- Next by thread: Re: alt gr does not work in remote desktop fullscreen
- Index(es):
Relevant Pages
|
