Stuck...Please Help

[Lethal]

I have a datalist box with a list of invoice numbers im pulling from the a recordset, using the adodc control. Now, i want to have an edit button on my form, and when clicked, pull of the invoice numbers whose length is less than 7. Would I need 2 list boxes or two adodc controls?? Or can i get away with just one of each, using an SQL query. thanks for the help

[barrk]

Why don't you just pull only the invoices with a length less than 7 in your initial query rather than having an edit button?

[Lethal]

Well, because all of the invoices that have a length of 7 are the correct invoices, the others need to be edited. Any other suggestion out there..thanks

Fill the datalist recordsource with a Select num_invoice from invoices where num_invoice <= 9999999, you can use the same datalist or another.

or

Select num_invoice from invoices where len(num_invoice) = 7

my two cents :)

[Edited by JuanCarlos60 on 11-03-2000 at 07:58 PM]