>Hi Larry,
>
>The view code is as follows:
>
>(I'm sorry I can't remember how to insert code in html page)
>
>SELECT Services.serv_id, Services.unit_id, Services.phb_id,;
> Services.invent_id, Services.install_id, Services.subscripno,;
> Services.which_svc, Services.service, Services.start_date,;
> Services.recur_fee, Services.descrip, Services.start_time,;
> Services.createdate, Services.house_id, Services.smoke_id,;
> Services.memb_id, Services.other_id;
> FROM ;
> lw!services;
> WHERE Services.memb_id = ( ?vp_membid );
> ORDER BY Services.which_svc DESC
>
>This looks OK to me......
>
>Wayne
try taking out the parentheses around ?vp_membid. What is memb_id - numeric, string, etc.? I wonder if it's trying to interpret something there...
Does it always give the error when trying to use it?
Insanity: Doing the same thing over and over and expecting different results.