Combo Box on Form to access Forms own Table

[ramasule]

Hello,

I'm sorry I just started access yesterday so please bare with me.

I was wondering if how to make a drop down combo box to select / go through a tables records.
In other words maybe this helps I want to make a drop down box to select
ID's on that table instead of using the little buttons at the bottom of the forum..... First, Previous, Next, Last, New.
So instead of clicking the next button and finding the page I would like to select the item from a drop down list.

For instance the application I am trying to build has a person table, and it has a table called permits. The permits table has dates and stuff and I linked it to a parent table Person. So every permit has 3 people associated with it.
Instead of clicking through the permits using hte buttons at the bottom I wish to just use a combo box in alphamebetical order to just pull up the permit I wish to look at.

Any hints, suggestions, or give up nows please post because I am very new to this and anyfeedback is helpfull.

Thank you for your time,

Derek Lucksinger

 

[rainman89]

do a search on combo boxes. youll find your answer there!

 

[BE19]

combo boxes

There are a myriad of examples out on the 'net. Here are a couple:
http://www.blueclaw-db.com/comboboxlist/
http://office.microsoft.com/en-us/access/HP052405811033.aspx?pid=CH063661991033
http://www.functionx.com/access/Lesson25.htm

lkp

 

[ramasule]

good thing the search only returned 500 hits, now I wont have to spend days looking through it all

If you could tell me approximentally what I'm looking for or a more technical term to google it would be appriciated.

Doing a search for "combo boxes" dosn't really help when I dont know what to look for in the combo box category.

Thanks,

Derek L

 

[rainman89]

dont google. use the forum search! its easier and they give u exactly how to do it

 

[ramasule]

the forum search returned 500

 

[ramasule]

http://www.functionx.com/access/Lesson26.htm
This link is proving helpful.

Maybe I wasn't clear in my question though.
I know how to make forms to lookup both the permit and the person table.
I have a form for configuring the person adn a form for configuring the permit.

The permit Table is as follows
Primary Key: Permit Number
Date issued
Date returned
PersonID <- Linked to person table

What I am trying to ask is on the permit form I have made a combo box that will let you change the permit number but it keeps all the other fields the same and updates the (new selected permit) with the values of the old permit. I would like to be able to select a permit number have the fields update to what is stored in that permit number and then be able to change the fields from there.
I.E. being abel to select the permit number rather then using the arrows at the bottom and scrolling through all the *edit Records*
I thank you for anytime you spend looking into this it is greatly appriciated,

Derek L

Edit: What im looking for is there a way to create a combo box for the records, but have the primary key listed in the combo box.