Referring to a form control in an update query

[Terri]

I'm trying to create an INSERT statement that inserts records where one of
the values should refer to a from control.

INSERT INTO dbo_CheckRequestPayments ( FundCode, CheckRequestID )
SELECT localGenerateExpenses.FundCode,
[forms]![frmCheckRequest]![CheckRequestID] AS CheckRequestID
FROM localGenerateExpenses;

When I run the select part of this statement I get a strange character
rather than the value in [forms]![frmCheckRequest]![CheckRequestID].
Referring to one control returns a chinese character.

A2002/SQL Sever 2000. The data type of the fields are both int. I tried
setting the format of both the form control and the query field to general
number.

Any suggestions?

[pietlinden]

maybe a dumb suggestion, but what happens when you create a select
query and show the value in the form? Something like

SELECT [tableName].[field1], [Forms]![OpenForm]![YourControl]
FROM [tableName];

Does it show what you expect?