I have a table with several fields, but in particular
Student Number (test)
Last Name (text)
First Name(test)
Grade(text)

These fields show on my form called Parking form. These fields are locked. I
wish to allow the users to add/edit fields. So I have a cmd button that opens
a new form called add/edit new student form. There the user can edit or add
a new student then return to the main form. The problem is when you add a
new student. That student will not show in the parking form unless you do
shift F9. I assume a requery command is needed but I cannot figure out
which filed, form, property setting, or correct syntax to use. I would
prefer to autmate this and not have user use shift F9. One user will never
figure that out. I have the same problem with adding a new make and modle of
car. But I assume I can modify the first answer to fix the same problem
there. Thanks for the help. If u need more infor let me know.