Hi there
I have inherited an Access application from a previous developer who has left the client. There is a form on which is subform and a subreport. The subform displays a list of brief invoice details and the subreport displays the full invoice. The subform is a continuous form. If a record in the subform is clicked then the correct record is displayed in the subreport using master and child link. That all works fine. However If I move down or up the list of records in the subform using the arrow keys then the record in the subreport is not updated. To get the subreport to update I must always click on the record in the subform
I have tried forcing a requery of the subreport from the onchange event of the subform but I can't get that to work. There are other forms in the database with a similar design that work correctly. I have a feeling I am missing something very obvious here!
Some pointers would be most welcome!
I have inherited an Access application from a previous developer who has left the client. There is a form on which is subform and a subreport. The subform displays a list of brief invoice details and the subreport displays the full invoice. The subform is a continuous form. If a record in the subform is clicked then the correct record is displayed in the subreport using master and child link. That all works fine. However If I move down or up the list of records in the subform using the arrow keys then the record in the subreport is not updated. To get the subreport to update I must always click on the record in the subform
I have tried forcing a requery of the subreport from the onchange event of the subform but I can't get that to work. There are other forms in the database with a similar design that work correctly. I have a feeling I am missing something very obvious here!
Some pointers would be most welcome!