why won't my table update when i enter data in the form?????

[nancie]

I am an access newbie, but i have gotten pretty far with my database so far, so please bear with me...
I have been entering data in a Products form, but it will not seem to update into my Products table, thereby causing me great amounts of grief and frustration when I try to run my queries...any suggestions?

many thanks!

 

[ColinEssex]

Hi

Make sure that the table is actually linked to the form.

Sometimes its easy to overlook the obvious!!

Col

 

[nancie]

Thanks Colin,

I thought that the forms were automatically linked to their parent table. If that is not the case, I 'm not sure how to link the two. Also, some of the information from new records entered in the Products form is transferring to the Products table, but alas, not all of it. Could you offer a bit more help?
Many thanks,
Nancie

 

[Tay]

In design view, you will see a small grey square in the top left of the screen (it's at the junction of the 2 bars with numbers - and I have no idea what it is called). Click on this and look at properties. By clicking on this square you will then be able to go to record source in properties and check that the table name you want is there. Also, have you checked that your joins (if you have them) are all ok? Check that in the Relationships window.

HTH

 

[nancie]

Thanks Tay,
I did what you said, and all seems to be okay. The record source is set to Products. I don't quite know what would be wrong in the relationships, since all the data is only shared between the form and it's recordset table. I'm beginning to get a bit more baffled...
Nancie

 

[Rich]

Delete your form, use the form wizard the create a new one for you