Solved ACCESS CHECK SAME VALUE IN ANOTHER FIELD

[georg0307]

Dear all,

could you please help me on the following matter? I need every time I put a new value in the field "HU_IN_MENO" (THE INSERT FORM appears with button +/-) that is equal to a field present in "HU_IN_PIU" of the entire HU_ISSUE table, I receive back a Msgbox that inform me that it already exists and show me the "HU_IN_PIU" / "UNIQUE REFERENCE". Thanks in advance.

 

[theDBguy]

Hi. Sorry can't look at your file right now; but, have you tried using DCount()?

 

[bastanu]

Please have a look at the attached, I hope this is what you are trying to do. I made the details form unbound and used OpenArgs to pass the unique value

 

[Pat Hartman]

Do it the other way around. Use a combo that selects values from a table. Then use the Not in list property to add new items to the Combo's RowSource table.

 

[georg0307]

Please have a look at the attached, I hope this is what you are trying to do. I made the details form unbound and used OpenArgs to pass the unique value

Hi many thanks for answer I have adapted for my use and is perfect thank you very much.

 

[bastanu]

You're very welcome, good luck with your project!
Cheers,