Printable View
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
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?
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]