Added a field but it doesn't save

M

MMC

I added a field on our form. It looks like it was okay but every time I put a
value/data in, the value/data isn't saved. Am I doing something wrong? Did I
add the field incorrectlY?

Thanks
 
S

Stockwell43

You need to add the field to your table then in the control source of the
text box select the field name that you entered in the table.

Example:

So you want to add a field to the form called "Cost"
Go to your main table in design view and enter Cost and select Currency from
the Combo Box.

Open your form in design view and from the Field List in your toolbar select
the word Cost and drag it to the form. Once you get it in place, right click
on the field and open the properties and go to the Control Source. Click on
the drop down and select Cost. This will now save the data you input in the
Cost Field on your form to the main table.
 
Top