Sub Forms Navigation

[roymcd]

Hey All ,

An easy one I am sure. I have a form "Invoice" with a sub form "Payments"

I dont know how I did it but I made the entire form navigate by the sub form.
( this means when I click "next" for the next record it is scrolling through the Payments ID's.)

Not ever Invocie has a payment so when I scroll through I do not see all.

All I need to know is how to swap what feild the table scrolls through.

(appoligies if I am not using the correct terms here. New to this)

 

[HiTechCoach]

Hey All ,

An easy one I am sure. I have a form "Invoice" with a sub form "Payments"

I dont know how I did it but I made the entire form navigate by the sub form.
( this means when I click "next" for the next record it is scrolling through the Payments ID's.)

Not ever Invocie has a payment so when I scroll through I do not see all.

All I need to know is how to swap what feild the table scrolls through.

(appoligies if I am not using the correct terms here. New to this)

Check the Main form's record source. Make sure that you do NOT have the payments table included. It should only be in the sub form.

 

[roymcd]

Yeah that was it. Have got it working now

Cheers mate.

 

[HiTechCoach]

Yeah that was it. Have got it working now

Cheers mate.

Glad to hear you have it resolved.

Cheers.