new records

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

Guest

I have just designed a new database for the first time. My form is all set up
and saved but when i enter data it will not save.
After typing in all the details on to the form, i then save the data and
move to the next record by using the new record button. At this point the
same text is shown on the new record.
I am not the smartest person so if anyone can help me to be able to save and
input new data it would be great.
 
Hi Fester,

Sounds like your form is not bound to a table, or your controls (text boxes
etc) are not bound to fields from your table.

Check your form's data source. Then check that each control has a Control
Source selected.

Hope that helps.

Damian.
 
fester,
If the data you entered on one record shows up on a new record (which should have all
blank fields) it sounds as though you haven't "bound" your form's text controls to any
fields in your table.

Every form has a table, or.. preferably a query behind it as a RecordSource that
defines what table and what fields you will be entering data for on that form.
If you've done that properly, using View/FieldList in design mode will dsiplay those
fields available for placement on the form.
For an expirement, select 2 or 3 of those fields from the Field List, and drag them
onto the form.

Each text control will have as it's ControlSource, the name of the table field that
will store that data. That text control is considered "bound" to that table field.
You should now be able to enter appropraite data in those fields, and it will be saved
to the table once the record is updated. If you go to a New record, those fields should
be blank, and waiting for additional record entries.

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions




Indicating what field in the table is "bound" to each text control will cause any data
entered in them to be saved to the table in their respective fields.
 
Thanks for that info it is helpful. Could you let me know how i link the form
to a table or if i need to design a table and where i need to do the inputing
of the details.

Thanks for the feedback
Fester
 
Back
Top