Hi Knight,

One kind request.

As per observations so far, had you posted the error completely, this would have been solved much earlier.

Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/jewler/admin/info_ring.asp, line 10

You subject showed only a part of the ERROR and your original post was not mentioned with any other clue, so had to do all formalities 1 by one to narrow down to the exact problem.

If I were you, I would have posted
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/jewler/admin/info_ring.asp, line 10

and

Highlighted the error line code, as you did in your last post, as the first step, than posting the entire code, which one would never go through completely abd there by chances of getting it solved gets lesser.

Cheers!

_________________________
-Vijay G
Strive for Perfection

Regarding the edit mechanism.

1) Populate the recordset with all values required.
2) Till End_Of_Recordset, display the rings checkbox 1 by one.
3) While doing so, check for the FLAG field that you have in DB for TRUE/whatever that says this checkbox has to be checked, and set its CHECKED property if that matches.

Hope that helps.
Cheers!

_________________________
-Vijay G
Strive for Perfection

ok dear i will perform as u directed thanks dear i have one query more

dear can u tell me one thing more i have saved different size of
ring such as 5.5, 6,6.5 when i will add ring via add routine we use
checkboxes how can i edit those in edit routine my edit routine u have seen
any idia pls tell me