Combo box

[yessir]

I am trying to get a combo box to poll a table

when the title is selected it should update the location field respectfully

and then the borrowed and such should be that corresponding to the title so as to update it

y won;t it work??

 

[coryt]

There are plenty of posts here that will answer your question. do a search for "automatically update" or "lookup and update"

 

[jeremie_ingram]

Take a look at this and see if it is what you were looking for. If so let me know and ill will explain it.

 

[yessir]

YES

Perfect,

your a saint! (hopefullY)

thankyou

 

[jeremie_ingram]

What I did was quite simple. I created a form based off of your table and selected all of the fields. Then I deleted the Title text box and label. I then added a combo box and when the wizzard prompted me, I selected the third optio of basing the forms display based off of the record selected in the combo box.
From theere is just a matter of formatting and arraging the fields.

 

[yessir]

You know What

i think i might have gotten it like that,

i am just a little fried at the moment, and you insight showed me the way!

i guess simple is...