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

Looking for cool/useful/clever examples of form usage!

P: n/a
Hello,
Does anyone has a suggestion where (website) to find a very good
collection of cool/useful/clever examples of form usage/programming?

Things I try to do, are not available in Northwind.mdb. Such as the
following:

I have two fields in my table: CostStatus and CostAmount. CostStatus
can take three values: known/unknown/other and I want to show this as
radiobutton, with known as default at top.

After the know radio button I place an inputfield for CostAmount. In
case known-radiobutton is chosen, the CostAmount textfield must be
activated and filled by the user. In case any of the other two
options are chosen, the CostAmount field must be emptied, de-activated
and grey (not selectable).

What I am having trouble with, is the interaction of field behaviour.

Thanks for your help!

Paul
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Paul" <al********@it4us.nl> wrote in message
news:f3**************************@posting.google.c om...
Hello,
Does anyone has a suggestion where (website) to find a very good
collection of cool/useful/clever examples of form usage/programming?

Things I try to do, are not available in Northwind.mdb. Such as the
following:

I have two fields in my table: CostStatus and CostAmount. CostStatus
can take three values: known/unknown/other and I want to show this as
radiobutton, with known as default at top.

After the know radio button I place an inputfield for CostAmount. In
case known-radiobutton is chosen, the CostAmount textfield must be
activated and filled by the user. In case any of the other two
options are chosen, the CostAmount field must be emptied, de-activated
and grey (not selectable).

What I am having trouble with, is the interaction of field behaviour.

Thanks for your help!


The three values for CostStatus need to be stored as numbers (1,2,3). Then you
use an OptionGroup with three RadioButtons within. In the AfterUpdate event of
the OptionGroup...

Select Case Me.CostStatus
Case 1 'known
Me.CostAmount.Enabled = True
Me.CostAmount.SetFocus
Case 2, 3 'unknown or other
Me.CostAmount = Null
Me.CostAmount.Enabled = False
End Select

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
Hi,

Thanks for your answer. It almost works. One problem I have, is that
the CostAmount.Enabled value (true or false) is not determined every
time you browse through records. It simply keeps the last value that
was set by any AfterUpdate of the OptionGroup.

Thanks for any help again.
Paul

"Rick Brandt" <ri*********@hotmail.com> wrote in message news:<Ek*****************@newssvr30.news.prodigy.c om>...
"Paul" <al********@it4us.nl> wrote in message
news:f3**************************@posting.google.c om...
Hello,
Does anyone has a suggestion where (website) to find a very good
collection of cool/useful/clever examples of form usage/programming?

Things I try to do, are not available in Northwind.mdb. Such as the
following:

I have two fields in my table: CostStatus and CostAmount. CostStatus
can take three values: known/unknown/other and I want to show this as
radiobutton, with known as default at top.

After the know radio button I place an inputfield for CostAmount. In
case known-radiobutton is chosen, the CostAmount textfield must be
activated and filled by the user. In case any of the other two
options are chosen, the CostAmount field must be emptied, de-activated
and grey (not selectable).

What I am having trouble with, is the interaction of field behaviour.

Thanks for your help!


The three values for CostStatus need to be stored as numbers (1,2,3). Then you
use an OptionGroup with three RadioButtons within. In the AfterUpdate event of
the OptionGroup...

Select Case Me.CostStatus
Case 1 'known
Me.CostAmount.Enabled = True
Me.CostAmount.SetFocus
Case 2, 3 'unknown or other
Me.CostAmount = Null
Me.CostAmount.Enabled = False
End Select

Nov 13 '05 #3

P: n/a
"Paul" <al********@it4us.nl> wrote in message
news:f3**************************@posting.google.c om...
Hi,

Thanks for your answer. It almost works. One problem I have, is that
the CostAmount.Enabled value (true or false) is not determined every
time you browse through records. It simply keeps the last value that
was set by any AfterUpdate of the OptionGroup.

Thanks for any help again.


Put similar code (just for the enabling/disabling) in the Form's Current event.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.