Have two fields with same values in one record and one input. How?

[itsrightthere]

My form is long so at one portion I have another textbox that copies my
initial input.

Example:

Field1........................................Field2
input..........................................input

Every code that I try that pulls value from previous record makes input
value all the same for ALL the records. Each input is different for
every record but is repeated twice in the same record. I also want to
know if there's a code that can check that there distinct values in
field2.

THanks.

 

[itsrightthere]

nevermind I figured it out
I bounded Field2 to the control source of Field1
just need a command to check for any doubles

 

[Guest]

SELECT YourTable.Field2, Count(YourTable.Field2) AS CountOfFIELD2
FROM YourTable
GROUP BY YourTable.Field2
HAVING (((Count(YourTable.Field2))>1));