Pulling a value from a form for an append query

[jaaret]

I'm writing an append query that appends the key id's of all clients who work for a particular company . I need to append the reciept ID for each appended record. I'm attempting to pull the receipt ID off of a loaded form:

ReceiptID: [Forms]![frmExpReps]![txtReceiptID]

The receipt ID for the record that has the focus is 270, but the query is returning the character "?". Why is it not returning 270?

Thanks in advance,
Jaaret

 

[dhookom]

I believe Chr(270) = ?. I'm not sure how your value got converted.

Duane
Hook'D on Access
MS Access MVP

 

[jaaret]

I'm not sure either, but this works, returning 270.

ReceiptID: CInt([Forms]![frmExpReps]![txtReceiptID])

Jaaret