Cannot Stop Updating Prior Record

[Earl C Phillips]

I am building a student register for a school for disabled children. There is a screen listing all students, one showing detailed student data chosen by #=IIf(IsNull([ID]),"(New)","Open")# clicking on "Open", one listing all the guardians, choosing a guardian by #=IIf(IsNull([ID]),"(New)","Open")# clicking on "Open", to diaplay Guardian details.

From the student list, I select and view student details, including a pointer to their guardian details. After selecting the first student details, and then viewing their guardian data, any subsequent student details and guardian details updates the prior guardian data with the next guardian's data.

How can I prevent the successive guardian details from updating the prior guardian table when it is exited? I view the guardian details using ADO recordsets populating a form. When I exit, it updates the previous record.

 

[boblarson]

It sounds like you may be using bound controls where unbound should be. Haard to say without more info. Either that or your table structure is off.

Can you post a screenshot of your form in both design view and regular view? Also, a screenshot of your relationships might help too.