First record value changing

[Tommo]

Hi,

I have built a simple database for a dance school.



The junction table that handles enrolments is behaving a bit weird.

I have a form that deals with class payments. This is linked to the enrolments table via datasheet.

When i refresh the datasheet (which is embedded in a form) after a payment the first record in the enrolments table changes its value.

Effectively the first student changes to whatever class i am currently viewing.

Any ideas?

Cheers

[pbaldy]

At a guess, your form is bound to that table, and without realizing it you are on the first record. If you've got a "find a record" combo, make sure it isn't bound (no control source).

[Tommo]

Hmmm. This sounds likely. Thank you. Will have a look at this tomorrow.

[pbaldy]

No problem; post back if you're still stuck.

[Tommo]

Worked. Thanks

[pbaldy]

Happy to help!