Access has wizards to help you write a stored procedure. They're limited, but they can help you get a start on it.
A form can have a stored proc as its data source. Then it has a section in the form properties where you can set the input parameters for the proc.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon