By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,853 Members | 2,144 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,853 IT Pros & Developers. It's quick & easy.

Option Group Controlled By Boolean Expression

P: 6
I am developing this computer/monitor inventory database and I want to see if a monitor is connected to a computer. I have two tables, namely "Computer" and "Monitor", and they are related by the "InstalledIn" field in the table "Monitor", which is essentially the barcode field of "Computer" ("MachineBarcode").

Now I want to have an option group in a "Computer" form displaying whether a computer has a monitor with the read-only options "yes" and "no". I typed the expression: (My.MachineBarcode=Monitor.InstalledIn) in the "Control Source" property of the option group, with default value set to 0 (False).

However this method never works. Is it the problem of the expression or I should use some other things other than an option group?

Thanks in advance for any help.
Aug 7 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
I have no idea what you are trying to do.

However, if you want an option group of yes/no to change where a computer has a monitor installed you can try the following:

=IIF([My.MachineBarcode]=[Monitor.InstalledIn],1,2)

This assumes that the first option is 'Yes' and the second option is 'No'. '1' normally represents the first option in an option box and '2' the second and so on.
Aug 8 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.