combo box

N

Natasha

I just have 2 small little problems that I cant seem to figure out, there
probably very simple solutions. First when I run a report for the callout
report it says theres no data, but there is data in the table, it’s just not
showing up. The second is when you select the model name on any of the forms
and then run a report for that data the model name comes up as a no instead
of the name. I would be grateful if you couldtell me how to solve these
problems.



Natasha
 
J

Jeff Boyce

Natasha

You don't mention the 'source' for the report. Are you using a table
directly or a query? If a query, does the query return data? Is there a
chance your report definition includes a filter?

We can't see your database. We don't know how you might have connected
[model name] on "any of the forms" to the query(ies) (?) that underly(ies)
the [report]. When you say "comes up as a no", do you mean "as a number"?
If so, there's a chance your underlying table uses a lookup datatype for
that field. The problem, as you've found, is that the table stores one
thing (the ID#), but displays something else (?model name). If this is the
case, you'd be better off changing that table field to a number data type,
and using a query that joins the table to the lookup table as the report's
source to get [model name] into your report.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Top