Razzak, The tables are the same and the form has the ID's.
When I use the command EDIT USING formname WHERE colname IN &varname, I get an error "parenthesis are required around the list for the in clause". When I change the code to EDIT USING formname WHERE colname IN (&varname), I get the error that "no data is found". ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, August 26, 2004 12:23 PM Subject: [RBG7-L] - Re: Check Box > > At 11:55 AM 8/26/2004 -0400, Joe Solomon wrote: > > >Razzak, > > > >Thanks for the code, but when I use EDIT USING formname > >WHERE colname IN (&varname) > >I get an error "No rows exist for the specified clause". > >When I replace &varname with the actual list of names, > >it works fine. > > > Joel, > > 01. Is the table used in the CHOOSE command the same for > the primary table in the form? > > 02. You are collecting the IDs in the CHOOSE command > variable. Does the form's *primary* table has those > IDs? > > That should give you a few clues! > > Very Best R:egards, > > Razzak. >
