Append query has become corrupt?

[Hecronis]

This is an odd one to me. I have an append query that appends 3 fields on a form to a table. It has been working well since I made if several months ago, up until I tried run it tonight. It will recognize 1 of the 3 fields with the correct value, 1 of the fields will have some funky Chinese (Possibly) characters in it, and the last will have a random letter value in it depending on the record that's on the form.

I had not made any changes to that query, any codes or information that are associated with it, or anything like that. I tried to make a new one and got the same results. I'm so confused right now.

I don't know if this will help but here is the SQL for the query.

INSERT INTO TblRent_StartDate ( ID_Number, Date_RentStart, ID_ClientFacilityAdmit )
SELECT TblClient_Info.ID_Number1, [Forms]![FrmClient_Info]![Date_RentStart] AS [Date], [Forms]![FrmClient_Info]![ID_ClientFacilityAdmit] AS ID
FROM TblClient_Info
WHERE (((TblClient_Info.ID_Number1)=[Forms]![FrmClient_Info]![ID_Number1]));

 

[JHB]

Have you tried a "Compact and Repair"?

 

[Hecronis]

I have not. I've heard of that but I'm unclear what it does.

 

[Hecronis]

I tried the compact and repair but it said that it could not use the file because it was already in use.

 

[Hecronis]

So I've been messing around with it tonight. I was able to do the compact and repair. I was fooling around with a test query and can't get a query to reference anything that is on that form correctly. So I guess this is a form issue, so I guess I'll move threads. Thank you for you help.