Continuous Form Part 3

[Paul H]

A funny thing happened on the way to release this very simple application. I've posted on these forms twice before and thought I had them working as I intended, but my internal client took the database out to a satellite location for data entry training and as I said, something funny happen. The form we are concerned with is frmTLFB. The combo box, cboClientID, drives the data displayed in the form. For almost every client, the data displays exactly as intended, but I have two examples where the form displays no data for the selected client. What's more, by hitting F5 the form refreshes and shows the related data. I have no idea why these two clients records fail to display and all the other records do. I am attaching a copy of the front and back end. All data has been anonymized.

The two samples in question are Susan Brown and Glen Watts .



PSH Outcomes FrontEnd v0.1.zip

[CJ_London]

the data is there - you just need to scroll up. The reason it appears blank is because it goes to the new record row at the end. All the other clients have a lower number of records so will display on a full screen.

If you reduce the form height, you will see the effect for other clients

[Paul H]

I'm wondering, without too much trouble, would it be possible to have the screen like this.




instead of like this?



Because I have to tell you this fooled several people, including me. If it's more complicated than it's worth, then scrolling up and down is not a problem and thank you for pointing out the obvious.

[CJ_London]

yes - just take out the line

DoCmd.GoToRecord acDataForm, "frmtlfb", acNewRec

in your combo after update event

[Paul H]

OK, thanks.