I do believe that I did read before that 255 was the max. Me being on the lower end of the mental retentive curve I had forgotten.
The following doesn't have 100% Kosher naming qualities, but as time goes on, I am fixing what I can.
Thankyou for attempting to answer my question, I will elaborate more:
this is the query:
SELECT DISTINCTROW USYSAccountsWithProblems.[Vendor Name], USYSAccountsWithProblems.[Account Number], USYSAccountsWithProblems.[Acct Contact], USYSAccountsWithProblems.[Contact Number], USYSAccountsWithProblems.[Contact Address], USYSCheckInformation.[Chk #], USYSLetterInformation.Opening, USYSCheckInformation.[Invoice Number], USYSCheckInformation.[Chk Amnt], USYSCheckInformation.[Inv Amnt], USYSLetterInformation.Closing, USYSLetterInformation.Signature, USYSCheckInformation.[Chk Date], USYSLetterInformation.Date, USYSCheckInformation.VID
FROM USYSAccountsWithProblems INNER JOIN (USYSLetterInformation RIGHT JOIN USYSCheckInformation ON USYSLetterInformation.[Letter Number] = USYSCheckInformation.[Invoice Number]) ON USYSAccountsWithProblems.VID = USYSCheckInformation.VID
WHERE (((USYSCheckInformation.VID)=2707));
The query definition changes based on the following on click event (which opens a form based on current record)
With myquery
.SQL = "SELECT DISTINCTROW [USYSAccountswithProblems].[Vendor Name], [USYSAccountswithProblems].[Account Number], [USYSAccountswithProblems].[Acct Contact], [USYSAccountswithProblems].[Contact Number], [USYSAccountswithProblems].[Contact Address], [USYSCheckInformation].[Chk #], [USYSLetterInformation].Opening, [USYSCheckInformation].[Invoice Number], [USYSCheckInformation].[Chk Amnt], [USYSCheckInformation].[Inv Amnt], [USYSLetterInformation].Closing, [USYSLetterInformation].Signature, [USYSCheckInformation].[Chk Date], [USYSLetterInformation].Date, [USYSCheckInformation].VID FROM [USYSAccountsWithProblems] INNER JOIN ([USYSLetterInformation] RIGHT JOIN [USYSCheckInformation] ON [USYSLetterInformation].[Letter Number] = [USYSCheckInformation].[Invoice Number]) ON [USYSAccountsWithProblems].VID = [USYSCheckInformation].VID Where [USYSCheckInformation].VID =" & Me.VID
End With
All I want to do, Is add USYSCheckInformation.[Wlkr #] to the select. Which works but when I add it to the query def for the onclick event it doesn't.. It doesn't include that part of the query at all.
This isn't really a big ordeal, since I can pull the information I want from a separate form.
I'm sure to figure it out sooner or later..
Thankyou for the help (already given) and in advance!
Cruz'n and Booz'n always.
This post shows what little I do at work.