Updating form from table

[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.

 

[PNGBill]

If you have a form open and data is changed in a table that would effect what is on the form you need to do a Requery.

How ever the data is changed may allow you to add code that will call for the form in question to Requery.

Just a point, are you adding a Field or a Record.

A list of Employees with Name and Telephone number has Two Fields (FullName & TelNum) but many records. One for each person listed.

 

[crcastilla]

Ok just so you understand it better 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).