i need a pop up msg

[bronson_mech]

i have a created a databse for material handling wat i need is i have stock query & a issue query, for example i have 10pc of candy in stock... in issue form if i enter 11 pc or more it should give a alert/notification that you don't ve enough stock to issue....... how do i get this pop up msg......

[BluffMeAllIn]

Hi bronson,

I am guessing macros but is the database designed using macros or VBA code, essentially a constraint needs to be put in so that the # issued cannot be greater than the # in stock. How this would be done depends on the method of design used in the database.

If it is through VBA code it would simply fall similar to the below when you click submit or save or whichever action from the issue form that actually executes the issue:

if stockcount < requestedissuecount then
   msgbox "The requested stock to issue is not currently available, there are only " & stockcount & " of this item in stock."
   Exit Sub
else
   ........ code as currently exists to do the issue
end if

For macros, would probably be easier to look at it if you were able to upload the database as I rarily use the macros but am sure I could easily determine how to implement the constraint.

Thanks,
Dave