You seem to have two sets of controls, lname, fname, and lname2, fname2. And 2 search buttons, and lots of duplicated code, this makes it confusing to read and debug.
Have you tried setting a break point and stepping through the code and seeing what path is getting followed? There also appears to be code missing here, because from your description of the problem something is getting set before the search button is pushed. Are you setting the values for any of the controls elsewhere? The first thing I would do is get down to one set of controls and one search button. Then I'd write one function called GetCardHolder(firstname as string, lastname as string) In this function you dynamically build your SQL depending on which parm(s) have been supplied (ideally you shoud have all your SQL in a stored proc, but that's an issue for another day). This will get all your data access code in one function and make it easier to see what's happening. Won't solve your problem, but will make it easier to get a handle on where it is. -- Dean Fiala Very Practical Software, Inc http://www.vpsw.com [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
