Proceed if record found

[esskaykay]

I’m sure this has been address numerous times but I can’t seem to locate. I have a combo field in a form where I key in a value and it returns and populates other fields in a different table. It works great except if someone keys in a bogus value. The entry progresses as if it was OK. I’d like it to verify the keyin existed before proceeding. If not, pop up a message “Parcel ID not found”.

Thanks,
SKK

 

[llkhoutx]

Dynamically set all record or row sources dependent on the cbo. Only specify the record or row sources if the cbo returns a value on the afterupdate event, otherwise the notinlist event will have fired.

 

[esskaykay]

Not quite sure what this all means, but I believe I resolved one my problems. I set the "Limit to List" = YES. However, I have a similar situation - only here, I want the entry to be unique. I have the field set to "no dups". This works fine except if someone enters a duplicate entry, it doesn't prompt until the record is committed/updated. By then numerous other fields have been populated. Is it possible to receive an imediate prompt if a duplicate entry is made?

Thanks,
SKK

 

[llkhoutx]

A duplicate is being added to the list, but not via the combo box. Adding a value to a list via a combo box takes about 15, or so, lines of code,

When a value in the list is entered, nothing really happens except for an autofill of the value. If a value is not in the list, the notislist event fires.

Something else is going on to create dupliates.