subform hidding first record

[cpampas]

Hello,
Everytime I update a new record in my continuous subform, the first record becomes invisible. I have to use the mouse rolldown to make it visible again.
I ve been trying most of the format properties of the subform, even creating a new subform, and still I cant solv this. any thoughts ?

 

[theDBguy]

Hi. Can you post a screenshot of before and after the update?

 

[cpampas]

Hi. Can you post a screenshot of before and after the update?

I attached 3 images, before update, after update, and finaly after mouse rolling down
thanks

 

[theDBguy]

Thanks for posting those images. I think you need to figure out why the blank line is not showing in your second image. Are you using any code behind your form?

 

[cpampas]

Thanks the DBguy, you were right I had code behind my subform that had to be updated, that was the problem, so on the afterUpdate event of the for I dis Me.requery, and on the afterInsert event DoCmd.GoToRecord , , acNewRec, and that did the trick
Thanks for your help

 

[theDBguy]

Thanks the DBguy, you were right I had code behind my subform that had to be updated, that was the problem, so on the afterUpdate event of the for I dis Me.requery, and on the afterInsert event DoCmd.GoToRecord , , acNewRec, and that did the trick
Thanks for your help

Glad to hear you got it sorted out. Good luck with your project.