I have a simple form which opens a report based on a query. It keeps asking me for 'Tendor No' even though it is IN the query and i am just specifing it in my docmd.openreport call.
I tried redoing the form, the report. and the query, but no matter what it prompts me for the value.
I have no idea what is going on here. Any ideas?
BTW: all the other fields work fine except this one. I can specify any other field and it filters it correctly, just not this one.
I tried redoing the form, the report. and the query, but no matter what it prompts me for the value.
I have no idea what is going on here. Any ideas?
BTW: all the other fields work fine except this one. I can specify any other field and it filters it correctly, just not this one.
Last edited: