Search through list box on form open

[Kaur]

Hi,

I have developed an application in MS Access 2000 where I am trying to
highlight a record in the list box in form 2 based on the record
selected in form 1. The form 1 lists all the Document names and allows
me to add new documents. Form 2 has a list box that displays all the
document names. Clicking on a document in the list box shows me the
details of the selected document. I have over 100 documents in the list
box.
Basically what I am trying to do is from Form1 select a document and
open form 2 where the selected document in form 1 is highlighted in
form 2's document list box (without filtering the list box). This way
user does not have to search for the document he/she was on in form 1.

Any help would be appriciated.

[ManningFan]

Take a look at the ItemsSelected property (use Access' Help file), I
think you might take something useful from it.

Kaur wrote:

Hi,

I have developed an application in MS Access 2000 where I am trying to
highlight a record in the list box in form 2 based on the record
selected in form 1. The form 1 lists all the Document names and allows
me to add new documents. Form 2 has a list box that displays all the
document names. Clicking on a document in the list box shows me the
details of the selected document. I have over 100 documents in the list
box.
Basically what I am trying to do is from Form1 select a document and
open form 2 where the selected document in form 1 is highlighted in
form 2's document list box (without filtering the list box). This way
user does not have to search for the document he/she was on in form 1.

Any help would be appriciated.

[Larry Linson]

You can't search through any Control in the Form Open event, because the
Controls haven't been initiated, yet. Form Load is the first event where
Controls are reliably available for use.

Larry Linson
Microsoft Access MVP

"Kaur" <ka***@saic.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...

Hi,

I have developed an application in MS Access 2000 where I am trying to
highlight a record in the list box in form 2 based on the record
selected in form 1. The form 1 lists all the Document names and allows
me to add new documents. Form 2 has a list box that displays all the
document names. Clicking on a document in the list box shows me the
details of the selected document. I have over 100 documents in the list
box.
Basically what I am trying to do is from Form1 select a document and
open form 2 where the selected document in form 1 is highlighted in
form 2's document list box (without filtering the list box). This way
user does not have to search for the document he/she was on in form 1.

Any help would be appriciated.