Hey guys,
I've got two forms. Form A which displays 'Customer purchases' and form B that allows the user to add customer details quickly (a sub form)
The issue I have is that I need requery form A upon closing from B to show the data added. This results in form A moving to record 1 rather than a new record that was previously selected.
Any suggestions guys?
Only thing I can think of is setting the onload of form A to:
Code:
DoCmd.GoToRecord , , acNewRec
But from the users perspective I don't particularly want that