By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

Search through list box on form open

P: n/a
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.

Aug 30 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Aug 30 '06 #2

P: n/a
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.

Aug 31 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.