[dacree324]

I am using a line of SQL code to change the record source on one of the forms I use after a sort is performed by the user.

Form_frm_ClientContactInformation.RecordSource = "SELECT * FROM tbl_ClientContactInformation INNER JOIN tbl_Account ON tbl_Account.[Account PSID]=tbl_ClientContactInformation.AccountPSID WHERE (((tbl_Account.AccountName) Like '*" & txtAccountName & "*'))"

The user puts in the Account Name, but because the name is not stored with the Client, the AccountPSID is, i have to compare the places where AccountPSID and Account PSID (client and account, respectivly) are the same, and filter it as such.

It works on all but one field. Randomly, when I use this and look at my new results on the ClientContactInformation page that results, the City field will appear as #Name?

I've done some basic troubleshooting, such as changing the control to make sure to point to City, and I've compared the City control to something else, like State, which is appearing, and they are identical except for obvious exceptions.

Is there a problem with the code, or is something more sinister occuring?

[OBP]

Have you tried putting the SQL in to a Query to see wehat results you get.
Without seeing the database it is very difficult to know what is going wrong.

[dacree324]

i'm having problems getting the zipped version of the file down to the manditory 500k, im stuck at around 700. I'm using winzip, is there a better way to do it?

[dacree324]

OBP,

I took your suggestion and put the sql code into the analyzer and looked at it. The problem is that in my Account table and in my Client table, I have fields marked as City. They would appear as tbl_Account.City and tbl_ClientContactInformation.City, which is not what the control was looking for! When I changed the name in the Client table, and reran the query, I was able to get the city to appear.

Thank you!