I have a task management database that displays all the info of any construction task on 1 form, (TaskSummarySheet). I have a command button that when pressed pops up another form to input the new task details with what I consider as pertinent info. All goes well until I press a command button "OK" on the "NewTask" form, the form closes but the new task does not show up on the main form, i have to either press the requery button or close the database down and restart for the form to show the new record. Why wont the new record show and is there a way of going directly to the new record to fill in other info?? Please help as i have been stuck on this for some time now.

In the close event of form2 DoCmd.Close,Form1
DoCmd.OpenForm1
HTH

Thanks for that it works a treat, could i trouble you 1 more time. Is it possible for the new record you have just created to be showing on the form when it opens? Much apperciated.