Continuous Form Headache

[Sullaway]

I have a main form frmCustomers with tab pages. On one of the tabs I have a
subform that I have made a continuous form. This displays a summary of
payments on one invoice #. I have given the user the capability of double
clicking on a line of the summary and going to the payment details form.
All of this works good. My problem is that if there are 3 records showing
the summary of payments and you double click the third record to look at
it's details when you close the details form and go back to the subform it
shows only the third record. The first and second are no longer showing.
If I click on the first record when it comes back all three still show.
Just as a test I placed a command button to go to first record. If I click
the command button it will allow me to see all the records again.

I know enough about Access to be dangerous and have tried all I know to fix
it. Could someone please give me a hand with this?

Thanks a head of time!
Shane

 

[RickSpr]

My first guess would be that the subform has scrolled to the third record. If clicking the first record doesn't cause the problem, it seems unlikely that it's being caused by a recordsource change or a filter, so all the records would still be there. Do you have a scroll bar in the subform control? (If not, you should, with a continuous form subform.) Do you have a navigation bar? Either of these should show that you're not positioned to the first record in the subform. You could also try pressing the PageUp key.

If that's not it, there must be something in your double-click code or in the payment details form that's changing the record source. After returning to the customer form, check it out in the immediate window. Type &quot;?frmCustomers!<subformcontrol>.Form.RecordSource&quot; and &quot;?frmCustomers!<subformcontrol>.Form.Filter&quot; to see if they've changed. Rick Sprague

 

[Sullaway]

Thanks for responding Rick. I'll try the suggestions you have given me.

Shane

 

[Sullaway]

Rick,

Your right with your first guess. The records are there. When closing the details form the subform is positioning back to whatever record opened it. No I do not have a scroll bar nor navigation. The reason is there will never be more than 4 or 5 funding sources paying on one invoice so for the sake of looks I would rather not have them besides even if I did use them, I still wouldn't have a real clean look to it. Do you have any suggestions on how to get back to the first record?

The subform is on Service Ticket and has a link using ServiceID. I am going to the details of the payment by a transparent command button over the summary fields. In the code to get the specific record to open in details I'm using the PaymentID. Another words there can be several payments on one service ticket. Do you think this could be causing something to happen?

I appreciate your help!
Shane

 

[Sullaway]

Rick,

I figured out the problem and wanted to post one more time so that I would not waste your time. Thank you for responding.

BTW the problem turned out that I had the form recalc OnActivate and it didn't like that. Requery works fine though.

Thanks again.
Shane