Drop Down box?

[ryanc75ca]

What I am trying to do is create a form that is basically a title page, and it will have a drop down box that lets someone look through my tables and pick which one they want to see. I am fairly new to Access and have no instruction book here at work so bare with me please. Is this possible?

Thanks in advance

 

[Tay]

I have replied to your other thread on General, just in case you didn't see it.

 

[ryanc75ca]

Thanks

Hi thanks I just seen it. I wasn't sure which header it belonged under since I don't know if a form is what I am looking for.

 

[jeremie_ingram]

First off, you should never allow users direct access to you tables. Once they get in they have bad habbits of thinking they are in excell and end up hoseing up the works.
You would be much better served if you displayed the results of a query or create a form (GUI) for them to use to interact with your data tables.

To open item from a combo box is fairly easy. You will need to do some VBA, but is not to bad.
I have attached a small example to show you what i mean. Let me know what you think.

 

[ryanc75ca]

Thanks

Thanks I think I get the idea and yes people screwing with my data would make me very unhappy haha. I unfortunatly can't open the attachment (damn corporate firewalls!) but thanks anyway. I will see what I can figure out