query returning ' for no apparent reason.

[Homegrownandy]

I'm hoping the reason is apparent to someone else here.



I want PONUM to display the ID number of that PO. As a test I have used the same query criteria to show the relating record.



This is the result:


as you can see it should read 39 in both. But PONUM shows only the apostrophe '.

[ranman256]

ive found using controls as a query text will do that.
try Clng(forms![add time]![Po_ID])
or
CStr(forms![add time]![Po_ID])

this can help it show.
(or add it as a query parameter)

[davegri]

Oddly, Chr$(39) is an apostrophe.
Take a look at the SQL for the query.
It'll be something like

SELECT [Forms]![add time]![PO_ID], PO_engineers.PO_ID FROM PO_engineers;

Obviously [Forms]![add time]![PO_ID] is not a field in your table.
Maybe

SELECT Eval(Forms![add time]!PO_ID) AS PONUM, PO_engineers.PO_ID FROM PO_engineers;

would work.

[Bulzie]

Can you just use the PO_ID field from table?
PONUM: [PO_ID]

Is that form open and if so, is the 39 value showing or an apostrophe in that field?

[Homegrownandy]

thanks a lot

[Homegrownandy]

Bulzie I didn't see your reply until now. This is on an unbound form for the most part. I was having other errors when it was bound.