I can't add a new record in a form. How Do I?

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

Guest

I have set up a form in access 2003 to manage my sheep, but once i have added
the information to the 1st record I am unable to add a new record. I have
tried adding a new record with any information in it but it still does not
work. I am aware you can create a table and use that to create your form, but
i dont want to do that because 1 record contains simmiliar information about
the sheep.

Can You Help Me? Please
 
Hi -

From your description, you have created a form that no table as its
record source. When you close the form, all the data in the controls
goes away with it.

If you want to save any data at all, you must create a table - that is
where the information is stored. A form only displays data, serves as a
means to enter it, or both. So, create your table first, then use the
table as the record source for the form.

HTH
John
 

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

Similar Threads

Separate Form 0
Add new records into source table on Form 8
Add New Record Button: How to Get Mouse Cursor in Specific Field Upon Clicking? 1
Can't Add New Record 8
No option for new record in Main Form 3
New record button 1
Linking Forms for new record 2
blank form, can't insert new record 11

Back
Top