Access 2007 populate form by clicking on records in a table

[mjackson918]

I am new to Access 2007 and I would like to be able to click on a record in a
table and have it bring up that record in a form. What is the best way to do
this, and if I have already created the form, will I have to create a new
form to accomplish this?

 

[Mr. B]

mjackson918,

You will not be able to do this starting in a table. You need to start in
your form. I would suggest that you add a combo box or a listbox that will
contain the unique Id and a descriptive value for all records from the table
but only display the descriptive value.
Here is a link that might help:
http://www.mvps.org/access/forms/frm0005.htm

You will have your form "bound" to your table and a have a control for each
field you want displayed.

 

[mjackson918 via AccessMonster.com]

Thanks for the help!

mjackson918,

You will not be able to do this starting in a table. You need to start in
your form. I would suggest that you add a combo box or a listbox that will
contain the unique Id and a descriptive value for all records from the table
but only display the descriptive value.
Here is a link that might help:
http://www.mvps.org/access/forms/frm0005.htm

You will have your form "bound" to your table and a have a control for each
field you want displayed.

 

[Mr B]

You are quite welcome. Glad to help

Post back as you have other questions.