Form - table

R

Rad

Hi,
I am in the process of building an image database. I am almost done with my
database. I included a field in a form which is not in my parent table. Now I
need to include it in the table. Can somebody explain me how to do it?

Thank you verymuch!
 
O

Ofer Cohen

I assume that the form is bounded aleady to the main table.
1. Open the table in design view and add the field you want
2. Open the form in design view
3. Open the form properties, by clicking on the top left corner of the form
4. Put the cursor in the RecordSource property of the form, on the right
you'll see a button with three dots, click on tha button
5. Now the SQL (Query) is open, add the field you added to the table in
stage 1
6. as you exit the query, it will ask you if you want to save, say yes
7. Before closing the form, save the form, it might close without saving
8. Go to the text box you create in the form, and add that new field using
the ControlSource of the text box

If the form is based on a query, then you can open the query in design view
and do only 5-8 stages

I hope that what you are asking for
 
Top