List Box Search

[NewfieSarah]

I have a table called Bear Sighting, A form called Search by observer.. A list box, containing all the observer names. I would like to be able to search through the database table 'bear sightings' and display only the sightings by the observer that I have clicked on... I would like to display them 2 different way at the same time... once in a list box and then again see them at the bottom of my form, displayed as records that you would see in the design view of my table... any can help, that would be great... I am not too familiar with the program so I will need specific details if you could thanks...




* Have A GREAT Day*

 

[WayneRyan]

Sarah,

Look in the Sample Databases forum, there are quite a few examples that
pertain to this.

Wayne

 

[WayneRyan]

Sarah,

Can you post the DB that you have? It will make it a lot easier if you can.

Remove unneeded stuff,
Tools --> Database Utilities --> Compact/Repair
ZIP into a file,
then attach.

Wayne

 

[NewfieSarah]

reply

well here we go here it is, I cant send the file cause it is to big, all my databases are big and I dont know why... I have taken aways a much as I an so I am not going to be able to send it to you. Thanks I have posted a subform help as well.. cause I cant figure it out I am using the ListBoxQuery database to help.. but I cant figure it out. it would be great it you could help..