report and drop down list?

[Geoff Cox]

Hello,

A friend of mine has made an Access (2003) database for a video store,
three linked tables members, videos and bookings. The videos table
has various fields including two (rating and type) which have list
boxes to allow choice from a drop-down box.

A query was constructed from the videos table only and produces
expected results in tabular form. However using the wizard to make a
report of this query has a strange effect. The resulting report
shows all of the options for the two list box fields with the chosen
one blacked out.

How can he get the report to just show the chosen value? And not all
the possibilities with one blacked out?

Thanks

Geoff

 

[tina]

sounds like the rating and type fields, in the videos table, are Lookup
fields. bad idea, see http://home.att.net/~california.db/tips.html#aTip8 for
more information.

recommend your friend get rid of the Lookup fields, changing them to
ordinary fields. and i'd recommend storing the rating and type options in
tables of their own, as

tblRatings
RatingID (primary key, probably Autonumber)
RatingName

tblTypes
TypeID (pk, probably Autonumber)
TypeName

these tables will be used as the RowSource for combobox controls in the form
bound to the videos table. and they should be included in the report's
RecordSource, linked to the videos table, so the report can use the
RatingName field and the TypeName field; the report should not have combobox
controls in it.

hth

 

[Geoff Cox]

sounds like the rating and type fields, in the videos table, are Lookup
fields. bad idea, see http://home.att.net/~california.db/tips.html#aTip8 for
more information.

Many thanks Tina, will pass on your thoughts.

Cheers

Geoff

 

[tina]

you're welcome.
and btw, for future reference: please don't multi-post. i'm referring to
your post asking the same question same day in newsgroup
microsoft.public.access.reports. for more information, see
http://home.att.net/~california.db/tips.html#aTip10.

hth

 

[Geoff Cox]

you're welcome.
and btw, for future reference: please don't multi-post. i'm referring to
your post asking the same question same day in newsgroup
microsoft.public.access.reports. for more information, see
http://home.att.net/~california.db/tips.html#aTip10.

I know - I should have posted to both in the first place.

Geoff