Data Display

[Imy South]

Hi Guys,

I have a question for you viewers. How do you display data from a table to a form for example I want to bring up all my details from the database to the form. The form is blank and if I type my name name no details come up. To say i want to update my details through the form instead of the table, how do I do this?

Imy

 

[EmmaJane]

Have you based your form on the table or a query ??

 

[Mod]

I'm assuming you didn't use one of the wizards to make the form, since it will normally take care of all of this for you.

First you need to edit the record source for the form. View the properties of the form. In the data tab the first property should be Record Source. In the text box type:

SELECT * FROM table_name;


Now, when you create controls, you can bind them to the data elements in the table. Create a control, view it's properties, the data tab, the control source property. Now that your form has a record source, you should be able to pull down combobox style options for this property. after clicking the down button all the columns of your table should be there. Pick the one, (like name) that you want the control bound to, and you should be good to go.