Changing database info from form selection

[Marie]

Hello,

I have a form that has a employee field where the user can
select an employee # and then preview a report. My
problem is whatever emp # is chosen in this field, when I
close out of this form and open my edit form which also
has an emp # field it automatically changes the emp # to
the one selected in the previous form. This is
problematic because it is changing the info in my
database...

some field properties for the emp # are:

row source type: table/query
row source: SELECT [EMPLOYEE].[PRI_SN], [EMPLOYEE].
[Surname], [EMPLOYEE].[Given_Name], [EMPLOYEE].[In_Active]
FROM EMPLOYEE WHERE ((([EMPLOYEE].[In_Active])<>Yes))
ORDER BY [EMPLOYEE].[Surname];

Would anyone know how to fix this? Let me know if you need
more details.

Thanks..

 

[John Vinson]

Hello,

I have a form that has a employee field where the user can
select an employee # and then preview a report. My
problem is whatever emp # is chosen in this field, when I
close out of this form and open my edit form which also
has an emp # field it automatically changes the emp # to
the one selected in the previous form.

This control should be unbound: simply set its Control Source property
to blank. This will let you use the control to select a record without
changing data in the table.