Form Question

[metaltecks]

I have a query called registration list. All the fields in this query are
shown in my form. I created an option group based on 3 fields from my query
that appears on my form. Later on, I generate a report, that will give me a
total of the number of times these options have been selected.

My problem is that i'm trying to make one of the option group selections to
be defaulted as a checkmark, but after I make the changes, it is still
cleared.

I've tried making changes in the properties box of the selection on the
form, to either as true, 1, or yes. But nothing.

Any suggestions?

 

[Joey Archer]

The value for a checked check box if ... -1.

Try setting that as the default value for that that field on your form. But
be aware that this will only show up in new records. The records that are
already in your database will need to be checked manually or via an update
query.

Let me know if this doesn't work.

Joey Archer

 

[KARL DEWEY]

I created an option group based on 3 fields from my query
To the best of my knowledge an option group uses a single field. The
underlying field can be text or number.

Did you create three option groups based on three fields?

The options group wizard lets you set a default.

 

[metaltecks]

I changed the default value and saved it, but when I created a new account,
nothing appeared again. Any suggestions?

 

[metaltecks]

I got the -1 to work when I set the default value on the property value in
the table.

I have a new question. Now that I got it working, when I create a report, it
is reporting as either a 0 or -1. Is there a way I can change it so it can
say the word yes?

Thank you

 

[KARL DEWEY]

A couple of ways. One is to nest IIF statements. The other is to create a
reference table with the two fields and join it in your query.