Hi There, Hope someone could help me out with the following. I am building a Timesheet where I use my Main Form to add Names, Times etc., and then use a subform next to it as a preview form. The subform is created through a query on main form table. Everything works great but should I notice that I made a mistake on say, time filled in for two weeks ago on preview form I don't want to scroll through records until I find the particular one, but instead click the record shown in preview form and the main form record should display the record which I could then edit. I have tried various coding which I found on the Net but nothing that works perfect so far.
{DoCmd.GoToRecord acDataForm, "MyMainForm", acGoTo, Me.Form.CurrentRecord. added In Click Event} this one actually works but not perfect, can't remember why as it were quite a few tries ago, but it's the closest I got so far.
Any assistance will be very much appreciated.