Re: Pop up box

[dr223]

Re: Pop up box

Hi,

I am working with Access 2003 database. I have a form which am intending to insert a "insert button" to find the details of a Student, such as address and name. I will have thousand of students. The idea is to have a button to click and give you a small pop up page with the following layout.

Student ID Name Address

AB1 Peter John ABC
AC2 John Martin YGH
AC12 Juliet Spencer XCV

Then below here a row where I could type the initiate the student_Id to send me to the Name and Address rather than scrolling up and down looking for details of a student. When I just type for example, A - it takes to all the student_ID starting with A, AB it filters it even further on the page.

Please could anyone tell me how I can do this in Access 2003, I want the data to be a pop-up.

Thanking you in advance

 

[Dennisk]

use a combo box, this has the required 'look ahead' ie it matches what you have typed in to the first occurrence of that text.

 

[ianward]

Hi - There is a post on the sample database section of this forum which i found to be very useful, and would probably suit your purpose very well, take a look at the link below to "Searching & Sorting" article

http://www.access-programmers.co.uk/forums/showthread.php?t=110203

Ian

 

[dr223]

Re: Combo Box

Hi,

I have a combo box, however, the combo box when ever I call it up it remembers the previous data typed in. I tried to re-create it when I was given the option remember the last data I checked the check box because the only other option was to save the data retrieved to a table, which I never wanted it to happen.

I only required the combo box to act as a reference.

If I want to it not to remember the last data input how can I impose such a condition.

Thanking you in advance