I have a form with subforms for entering test scores. The main form contains student info and subforms contain scores. There is a command button that opens another form to add students if they aren't in the database. I've tried refresh code command button on the add form after new students are entered but I can't get it to refresh the main form. I also tried it for activate, resize and current events on the main form with no success. When I tried adding refresh code to the main form and then try to exit the form or go back to the add form Access locks up. I hope someone can help me with this. I can usually find a solution on this site for problems but this one is getting the best of me.
Refresh locking system
- Thread starter ezpc
- Start date
Thanks for your reply jatfill. I had tried requery too but I had so many events happening that they were conflicting with each other. I finally decided just to have the main form close(instead of hide) and then it is reopened when the add form is closed. Probably not the best way but the easiest for now.
