Newbie questions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an existing table and form, the form was generated from the table
using the form wizard. I want to add a new field to the table and add a new
textbox to the form mapping to this new field. I seem to have problem
locating the "control source", seems like this existing form can't find the
new field I have added to the table. I saved the table but I still can't add
the new textbox to the form while the field has already been added. What's
wrong?

Thanks!
 
Is your form based on a table or a query?

If the forms "record source" is a query, then you will have to update that
query to include the new field.

Open your form's property box and look at the "record source" in the "data"
tab. Click the elipse to the right of it and it will open up and allow you
to mdify the query.
 
1. Create new field on the table ie : name
2. open the form in the design view .
3. create new control texttbox/combobox/....on the form from toolbox
4. select that new control and open property for that control .
5. There are five tabs : Format , data , event , other , all
6. select data tab .
7. on the first list : control source , click combo box .
8. your new field should be on the list .
9. select that new field .
 
It's based on a table, I can see that the new field is not listed in the
Field List of the form. What to do?
 
I think your form record source property is not based on the table but based
on the
query .

0. You could create new form based on the table .
1. select the table which you already add new field .
2. select database toolbar , form .
3. select wizard you want .

Or if you want to create it manually ,
1. Open form in design view .
2. Open form property from Menu bar View - properties
or right click - properties .
3. Choose data tab .
4. Select record source property -- the first list .
5. choose the table which has been changed
6. click the control you want to give new control source ( text
box/combo/checkbox..)
7. Open the property -- look number 2 .
8. Select control source .
9. Now your new field should be there .
 
Back
Top