Need help with altering a form in Access Database

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

I'm working in a database that has a form for each company with text boxes in
each form (eg- there are places for us to enter comments about the
companies.) What I want to do is add new text boxes along with new headers.
At least superficially, I have been able to do this by going into design mode
and making the boxes and headers I want. However, when I go back to form
view and enter information into the boxes, the information does not save
there. If I open up the database again in the future, the boxes and header
is there, but the box is just blank (the information I entered has
disappeared). I would really appreciate your help. Thanks so much!
 
All data in Access is stores in tables. A text box on a form only displays data
that is stored in a table. Your new text boxes need to be bound to table (or
query) fields in order for you to be able to save what you enter in them. The
first step would be to add new fields to the appropriate table (I'm assuming
that the fields are not already there, since this is something new you are
trying
to add). Then you need to set those new fields as the Control Source of your
new text boxes. If your forms recordsource is a query, then you will need to
add those new table fields to the query before you can bind the form controls
to them.
 
Back
Top