Please Help Updating Form from Table Important

[crcastilla]

Hi, I'm a total beginner at Access 2007. I created a table which I will update with a new record each week. I also created a form and some of the information form table i wanted it to be in the form. I went to Add Existing Fields and added the field i wanted. The problem that when i create a new record on the table i want that field to automatically update to the number on the form. Is there a way to do this? Please I really need the help if you don't understand what i am saying let me know.



Thank you in advance.

[June7]

Not really understanding your issue. You are adding record directly in the table? What number from form? Why aren't you using form to add record and data?

[crcastilla]

Ok for example, you see the Heading S1 on the table and you see the S1 on the form? When I put the first record on the table it said the S1 was 34 and I will update that info weekly. The updated information which is the second record has a 45. How can make it so the S1 on the form automatically updates with the information I'm putting in the table. (It would always be the newest record I put). Do you understand it a bit more?><

[crcastilla]

[crcastilla]

Attachment 4207

Attachment 4208

thats the form and table pictures

[June7]

Form opens to the first record of its recordset. The form's recordset would have to be filtered to only that record or you have to move to that record of the form's recordset.

Again, why are you entering data directly on the table?