can i use sql procedures and functions in ms.access instead of making
programmes in visual basuc, as i have no idea to do programming in visual
basic, as i have two forms one is main form and the second is the sub form i
wan to populate sub form on the basis of the the value in ...

I get the following error when adding a new record to the underlying
recordset of my form:
data added database won't displayed form because doesn't satisfy
criteria underlying record source.

Can someone off me some starting air code for the following?
How do I have a stored procedure send a return value,
then have my code capture the result?
Here's what I'm trying to do... in a form's code, I need to check if a