Search for existing record

[KH Ahmed Bara]

Please, i have a data entry form (form1) linked to a table (table1) containing a field [PIN_Number] of which i want it to be if a user entered value to the field [PIN_Number] then it will search for it existence in table1 and it will validate only if it is exist else it not validate the value. any help please?

[Jen0dorf]

Hi

I suspect a bit more information would help claify exactly what you want?

I'm assuming that the user types in a number ( Pin NO) and if it exists in the table then something happens?

If that is the case then a possible way would be to get the user to enter a pinno in a "textfield" and then run a query with the criteria set to [pinnumber]=[textfieldvalue]

Just a thought but do supply more information

cheers

Ian

[KH Ahmed Bara]

thanks for your response, what i mean is that my table1 has [PIN_Number] field containing 20 rows of recorded PIN numbers, in my form there is [PIN_Number] field and a command button cmd1, all i want here is if a user click on cmd1 it will open form2 if an only if the Pin number entered matches any of the existing 20 recorded PIN number in table1.

[orange]

Watch this free video by Steve Bishop for ideas.