Error on Form!! HELP!

[Rixx]

Hello Access World Pros!

I have a problem with some errors on a form/query that has been running circles around me for 4 hours now on a saturday night!!

Im trying to implement an error control message when a user does not select an employeeID on the main form, whilst they are on the subform. But with no joy! Also, I run into errors when a user enter the same item twice on the same subform! Access exclaims that there are duplicate values.

Please look at the simple access db attached and use the "acq" form. Maybe someone out there can enlighten me coz in all honesty im stumped!!

Cheerz

 

[MStef]

Hello Rixx!
About "...when a user does not select an employeeID"
look at "Acq Subform" Sub ItemID_Change.
About "...errors when a user enter the same item twice
on the same subform". It's normal because of
"AcqID" and "ItemID" is a PRIMARY KEY in
"AcqDetail" table.
Primary key can not be repeated.
Look at "Acq Subform" Sub Form_Error.
(MStef alias Štef)

 

[Rixx]

Hello Stef!

What can I say? You sorted my problem out 'exactly' as required!! Thank you very much I really appreciate it! Looking at your changes, it makes you think how a little problem can drive you around the bend and take you to hell and back because you dont know what to do!! The code you added/changes you made have achieved wonders!

Thanks again!

Ricky