that did not work. Running a recovery application on the file and it is recovering the db. It must be corrupt.

what is the sql server service acct (default)?

That's the first thing I tried, no cigar.

I found the correct syntax:

Forms(MyFormName).Controls(MyTemplateName).SourceObject = MySubFormsNew

Forms(MyFormName).Controls(MyTemplateName).Name = MySubFormsNew

I tried it the first time before replying and it gave me an error msg...i tried again now and it worked...must have fat fingered something. Thanks!

Only 1 thing i just noticed.

in my loop I declare the @SEQ. I use this to give me the starting number. So if I want to start from...

Excellent!

This worked and the article is very interesting.

Thanks

It is a SQL View. I found out what my issue was. It was an ID field that was not set as autoincrement. The table would not...

I found the answer to my own question:

@MyTable + '.' + REPLACE(@MyFields,',',',' + @MyTable + '.')

Thanks for the link, it has good information there for what I was looking for and more!

Yes, ReportListX is the unboound subform2 in my main form. I've close out of my app, but will try again later and reply back if your solution worked.

I figured it out.

Reports("mytable").recordsource = "Select * from mytable"

found my error, this works. Thanks! higgim, your code gave me the structure I needed for my query below.

;With ClientDomains_CTE3

AS

(

SELECT ClientDomains.DomainType

, ClientDomains.ClientVndNbr

, ClientDomains.ClientVndName

, RTRIM(REPLACE(

REPLACE(

REPLACE(

REPLACE(ClientVndName, ' CO ',...

Thanks for the reply with good code. Sorry I took long getting back but I went back to the business person and asked for these requirements in the original...

Here's an attempt at it. I'm getting an error msg on line 9 (Incorrect syntax near '>'. Can anyone tell me why I am getting the error msg?...