I am a newbee to access. Please bare with me.
I work at a school and created three tables to track student information. I created a form to input data from all three fields using the wizard and everything worked. I then needed to add a new line in one of my tables and when I went to update my form, it couldn't find the new field.
How do I update my list of available fields for my form? I tried to bind the text box to my field but it then became an expression and I couldn't enter any data. I ran the wizard again and created a new form but I can't keep doing that everytime I need to modify my table.
What am I doing wrong?????

Try deleting the recordsource for the form, saving the form, and then readding the recordsource. Access seems to keep the original list and this should make it refresh itself.

I was able to delete the record source from the form's properties. How do I add more than one table to the record source? I need to use my form to imput data into three different tables. I can't seem to get it to take more than one.