Need help with altering a form in Access Database

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!
 
L

Linq Adams via AccessMonster.com

You say that you go into "design mode" and add textboxes, but you say nothing
about adding fields to your underlying tables! A textbox that isn't bound to
a field in a table won't "hold" the entered data when you re-open the form.

Also, having "a form for each company " sounds like you have a seriously
flawed database design.
 
B

Beetle

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top