Setvalue to -1 in option field in subform

  • Thread starter syedalna via AccessMonster.com
  • Start date
S

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.
 
S

syedalna via AccessMonster.com

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

Jeff said:
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
Click to expand...
[quoted text clipped - 4 lines]
is there away to do this?.. your help is needed.
Click to expand...
Click to expand...
 
J

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/


syedalna via AccessMonster.com said:
i am working with CHECKBOX (yes/no, 0/-1)...

Jeff said:
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
Click to expand...
mark
[quoted text clipped - 4 lines]
is there away to do this?.. your help is needed.
Click to expand...
Click to expand...
Click to expand...
 
Top