Form modifies record when it should not

[omsoft]

I am not sure this is form-related, but do not want to cross-post.

I have a form where the user would select a program from a list box bouund
to a table and year. When the user clicks submit, the form invokes another
continueous form which is bound to a select query. This query returns several
records beging sessions for that program and year. The query is a parameter
query based on the data entered in the first form.

In the continuous form, program name and session name are locked fields and
there are a few other unlocked fields which the user can modify.

There are two questions.
1. The user when they either update or cancel the continuous form, the
program name in that lookup table is updated with program ID in the first
record. For example, if the user was looking at program id 10 with name
prog10, the first record in the table (id =1, name = prog1) field program
will be updated by 10.

I have tried everything, but can not figure out why this is happening.

2. The second question is that when I try to load the continuous form, I get
error 2501. I trapped the error and am currently doing nothing about it, but
I wonder if this is related to 1 above.

Any ideas will be greatly appreciated.

Thanks,

 

[omsoft]

The record get updated when the continuous form is loaded and not when the
user clicks either update or cancel on that form.