Storing Values from an Option Group

[Bentley]

Hello,



I am having difficulties with a report from option labels. I created the set of option labels and the values is being stored in the table, and when I make the report, the value for that is displayed instead of the name which is what I need. Any suggestions as to what I am missing?

thanks,

Bentley

[Micron]

Possibly the sql/query behind the report does not reference the desired field and/or the report control you expect to see the desired value in is linked to the wrong table/query/sql field. You'd have to provide more info if that doesn't help. We'd need to know where the "name" field is and probably info on the report design, including the sql behind it.
You are assigning the chosen value button (not label, right?) to a frame to ensure you get the right number?

[Bentley]

I do not have any sqp/query behind this. I created the option box to select the building code required. This info is stored in a WO table, and yes, it is assigning the value not the text label. I would like to see the text reported as the number value isn't meaningful on a report.

I am very green when it comes to access, and I appreciate any and all help.

[John_G]

An option group only has a numeric value, corresponding to the value assigned to the selected option. You would need another table to decode that value into the corresponding text. You can't determine the caption in the option label with VBA.

[Bentley]

Thanks. I was hoping there was an easy way to get this info.

[Missinglinq]

If, for instance, your Labels in the Option Group were

Dog
Cat
Cow

in that order, on your Report have an Unbound Control and use this as the Control Source:

=IIf([AnimalType]=1,"Dog",IIf([AnimalType]=2,"Cat", IIf([AnimalType]=3,"Cow","")))

Notice that the final argument of the last IIF() is a Zero-Length String {""}, and that the number of Closing Parens {)))} must be equal to the number of IIFs used.

Linq ;0)>

[Micron]

Or if the table has a field that contains a text value that's associated with the numeric field you're storing, you get it via a query and base the report on a query that encompasses all the fields and records you need rather than basing your report on a table. I wrongly made the assumption that the report was based on a query or sql statement because reports are generally not based on entire tables - rather combinations and/or subsets of them. Those subsets are created using queries.

[Bentley]

Thanks missinlinq. The only step I can't get is the link between the form labels and the record. I keep getting an enter parameter when I run the form. I have the control source looking up the stored value with the code you provided. This is probably too advanced for me at this time.

Ben

[Bentley]

I meant when I run the report not form. My mistake.

[Missinglinq]

...The only step I can't get is the link between the form labels and the record.

Sorry, but I have no idea what you man by the above! You simply have to tell Access what text you want to appear for each Value from the Option Group...i.e. where I have 'dog,' 'cat' and 'cow' you need to supply whatever text you want to appear on the Report. There is no way (that I know) to do this automatically.

Linq ;0)>

[orange]

Bentley,

Do a compact and repair of your database; then create a zip file and post it so we can see what you are working with.
As 'Linq said, we're not following/understanding your post.

[John_G]

The only step I can't get is the link between the form labels and the record

The only way to change report labels (or form labels) dynamically is to use VBA, something like:

me![labelname].caption = ...(some value), where the value is calculated from some report data. for a report, you would probably put it in the On Format event of the detail section.

I keep getting an enter parameter when I run the form (report)

That usually happens when a query contains a field reference it cannot understand, either in an expression for a column value, or a criteria expression.

What is the record source for your report?