Search results

@arnelgp I must admit the support you have given to me. Thanks a lot. for defining the variable I was doing it at main hint from and this did not thought to put it on a sub form. Warm regards,

@arnelgp I have attached my db, if you please can define the variable thisID at an appropriate level? I have tried to adjust it various times on different levels but not successful. Second thing, this duplicate check only works for the data displaying in form currently and do not check for...

I added the following variable in module but still facing with same error. Dim thisID As Long

still facing with same error even after changing the validation and defining thisID moduel wise. can you please test it at your end?

@arnelgp an error found, when tried to enter a new record and entered unique or new values for drawing and rev and then move to next filed and then return back to rev and change rev value to any existing one. then error appears" item not found in this collection. screenshot is attached.

@arnelgp I checked my form, controls are working fine and smooth, I will appreciate for the attention given to this task. Thank you so much.

@arnelgp I tried your provided code but I am facing with an error. I have attached db with tables and forms, If you have a look on it please. Regards,

Below is the code which I was using to check duplicate on one field [DocumentNo] only and that was working fine. Later one user asked me to check duplicate on two fields. Later on I could not manage 'how to check duplicate on two fields [DocumentNo] & [Rev] and one field [Rev] could also be...

Above code is working fine in order to display combo box values in text box. Thanks arnelgp. For handling duplicate I have attached error screenshot which I can not handle. further assistance is required please. @Pat Hartman The total existing data contains 20K+ records and I don't know why...

Thank you for combo box, will try. when tried duplicate value function it displaying an error.

duplicate drawing with Rev,,,,,,,ITS WORKED FINE. Thank you arnelgp. now require combo box value to display in a text box. pl refer to attached screen shot.

for displaying the description in combo, I did the same procedure as you advised but want to show the description in a text box separately based on the record selected in the combo. For duplicate, I can not choose this option as I have existing data which violate the the condition. I need to...

Hi there, A) I have table document control which has two fields DocumentNo Rev I want to check duplicate on both of fields and prevent user to enter record. For information Rev field may have blanks B) A combo box has two columns code, description when user select a record in this combo I...

My name is Amjad, I am from Karachi, Pakistan. I found this forum very useful to resolve the issue in my daily work activities in MS Access. I used to work in MS Access in the past around 12 years ago and then I move to KSA. After returning from there, I have found an opportunity again to...