Setvalue to -1 in option field in subform

[syedalna via AccessMonster.com]

I have a Mainform & subform (data from query100). when query data on query100,
it show in the subform... and i have to click on the [option] field to mark
it down.

what i am looking for is a way...when daya is query and show in subform.. its
automatically set the mark [option] field to -1.

is there away to do this?.. your help is needed.

 

[Jeff Boyce]

I may be thinking of something else, but I thought option groups in Access
started with a value of 1, by default. Are you working with a checkbox
(true/false, yes/no, 0/-1)?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


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

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

 

[syedalna via AccessMonster.com]

i am working with CHECKBOX (yes/no, 0/-1)...

I may be thinking of something else, but I thought option groups in Access
started with a value of 1, by default. Are you working with a checkbox
(true/false, yes/no, 0/-1)?

I have a Mainform & subform (data from query100). when query data on query100,
it show in the subform... and i have to click on the [option] field to mark

[quoted text clipped - 4 lines]

is there away to do this?.. your help is needed.

 

[Jeff Boyce]

Is the checkbox bound to an underlying field? Is the checkbox in the main
form or the sub-form?

I don't understand "mark it down". How do you know when the checkbox should
be checked? How will Access know when the checkbox should be checked?

If you are saying that the checkbox should be automatically checked, then
why bother even showing it? You could add code to an event that sets the
underlying field to True.

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


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

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

i am working with CHECKBOX (yes/no, 0/-1)...

I may be thinking of something else, but I thought option groups in Access
started with a value of 1, by default. Are you working with a checkbox
(true/false, yes/no, 0/-1)?

I have a Mainform & subform (data from query100). when query data on query100,
it show in the subform... and i have to click on the [option] field to

mark
[quoted text clipped - 4 lines]

is there away to do this?.. your help is needed.