Options for a Report vis Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Ross - 10 Oct 2005 07:47 GMT

I'm new at Access so please bear with me.

I put together a Form without a data source. Just unbound text fields to
allow someone to enter some min and max values to control a report. I
then make a control to open the report. (I tried both a Macro and via
VBA.) The report has a source query which references the min and max
values from the first form. I seem to be getting "junk" in these
references. If I put these values referring back to the form in the
query as expressions with their own columns I see nothing be maybe some
high ASCII characters. Help?

Reply to this Message

Allen Browne - 10 Oct 2005 09:32 GMT

It sounds like Access is misunderstanding the data types here.

That can happen with:
- unbound controls on a form;
- calculated fields in a query;
- UNION queries;
- Variants in VBA code.

For suggestions on how to avoid the issues, see:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I'm new at Access so please bear with me.
>
[quoted text clipped - 5 lines]
> these values referring back to the form in the query as expressions with
> their own columns I see nothing be maybe some high ASCII characters. Help?

Reply to this Message

David Ross - 12 Oct 2005 13:33 GMT

> It sounds like Access is misunderstanding the data types here.
>
[quoted text clipped - 8 lines]
> at:
> http://allenbrowne.com/ser-45.html

That was the issue. Thanks. Not obvious at all.

Reply to this Message