Adding records using form based on stored procedure?

  • Thread starter Thread starter ZRexRider
  • Start date Start date
Z

ZRexRider

Hi,

Is it possible to base a form on a stored procedure that has 2 or three
joins and be able to add records back to the database?

I have a fairly straight forward SELECT in a stored procedure that when
run in MS-Access ADP does not offer a "New" row in the results grid but
if I cut and past the same code into a View it does.

If I remove the joins from the SP then it looks like it's going to let
me add. Should I give up?

I'm not using the view because I am passing 2 parameters and I also
want to do some IF/THEN logic. I just want to be able to add new
records as well.

Thanks
 
i think that if you set the 'unique table' property you shouldn't have
a problem.

try to take away the join and do everything on lookups (combo boxes)

-aaron
 
ps what is your if then statement? you sure you can't use the same
logic in a view?
share it with us; usually a combo of nullif, isnull, coalesce lets us
do if then in a view.. or case when then at least

fiddle with it; keep up the good work

and give us your friggin sql statements!
 
Back
Top