Re: Option Group Problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

By option group's value, I do indeed mean the 1 or 2.

If you want to store that value, then you'll need to add a field to your
table to hold the value, add that field to the form's RecordSource query,
and bind the option group to that field.

--

Ken Snell
<MS ACCESS MVP>

"Emma" <Emma@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C6E7A2FF-15F6-4E9A-A2DF-8704A8211DBC@xxxxxxxxxxxxxxxx
> No, I don't think I do have a field to store the option groups value. Yes
> I
> want to store the sum in the OverallMark field. Not really very sure what
> you
> mean by option groups value, do that mean the 1 or 2 default values or in
> my
> case Foundation or Higher?
> If yees, how would I do this, so that the value is stored on each record?
>
> Thank you!
>
> Emma
>
>
> By Option Group value
>
> "Ken Snell [MVP]" wrote:
>
>> So what are you wanting to store in the table field named OverallMark --
>> the
>> sum of the grades? or the value of the option group's selection? (I am
>> understanding that the control named OverallMark is bound to the field
>> named
>> OverallMark, so it would appear that you want to store the sum of the
>> grades
>> in that field. Do you have a field for storing the option group's value
>> for
>> that record?)
>>
>> --
>>
>> Ken Snell
>> <MS ACCESS MVP>
>>
>>
>> "Emma" <Emma@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:439579CE-22CA-4B52-9765-55CF3A184D25@xxxxxxxxxxxxxxxx
>> > To put the value of (GermanCourseworkMark+German
>> > FoundationExaminationMarkF)
>> > or Higher(GermanCourseworkMark+GermanExaminationMarkH) i have used code
>> > so
>> > that when foundation or higher from the option group is selected, the
>> > total
>> > of this calculation automatically appears in the 'OverallMark' box.
>> > N.B. Frame108=my option group
>> >
>> > Private Sub Frame108_Click()
>> > If Frame108 = 1 Then 'Foundation
>> > Me!OverallMark = Nz(Me!GermanExaminationMarkF, 0) +
>> > Nz(Me!GermanCourseworkMark, 0)
>> > Else 'Higher
>> > Me!OverallMark = Nz(Me!GermanExaminationMarkH, 0) +
>> > Nz(Me!GermanCourseworkMark, 0)
>> > End If
>> > End Sub
>> >
>> >
>> > sorry, I hope that is slightly clearer. Thank you very much for helping
>> > with
>> > this!
>> >
>> > Emma
>> >
>> >
>> >
>> >
>> > "Ken Snell [MVP]" wrote:
>> >
>> >> Let me be sure that I'm understanding the terms that you're using.
>> >>
>> >> In the first post, you mentioned that the option group has a value of
>> >> 1
>> >> (Foundation) or 2 (Higher).
>> >>
>> >> You then mention that selecting 'Foundation' in the option group then
>> >> puts a
>> >> value of 'GermanCourseworkMark' and 'GermanExaminationMarkF' in the
>> >> 'OverallMark' textbox.
>> >>
>> >> Selecting 'Higher' in the option group then puts a value of
>> >> 'GermanCourseworkMark' and 'GermanExaminationMarkH' in the
>> >> 'OverallMark'
>> >> textbox.
>> >>
>> >> And your last post says that the 'OverallMark' field, to which the
>> >> textbox
>> >> is bound, should store the value of the option group.
>> >>
>> >> I am confused about what you actually want to store in the
>> >> 'OverallMark'
>> >> field... is it the value of 1 or 2 from the option group? or the text
>> >> strings 'GermanCourseworkMark' and 'GermanExaminationMarkH' or the
>> >> text
>> >> strings 'GermanCourseworkMark' and 'GermanExaminationMarkF'?
>> >>
>> >> Please provide more details. I apologize that I am not comprehending
>> >> the
>> >> information that you've posted.
>> >>
>> >> --
>> >>
>> >> Ken Snell
>> >> <MS ACCESS MVP>
>> >>
>> >>
>> >> "Emma" <Emma@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:44BCB5B5-0550-438E-A136-7D865243F70E@xxxxxxxxxxxxxxxx
>> >> >I wanted the value to be placed inthe 'OverallMark' field if thats
>> >> >what
>> >> >you
>> >> > mean, but if I select the Option Groups control source as
>> >> > OverallMark
>> >> > then
>> >> > it
>> >> > gets bound and I cannot select an option.
>> >> >
>> >> > I have one form which doesn't update the OptionGroup between each
>> >> > record
>> >> > and
>> >> > another form which doesn't update the OverallMark between each
>> >> > record,
>> >> > so
>> >> > i'm
>> >> > about halfway there with it, because both forms must both function
>> >> > similarly...Sorry if i'm not explaining my forms properly, or I'm
>> >> > not
>> >> > answering your questions properly, my knowledge of Microsoft Access
>> >> > isn't
>> >> > great, I haven't really been using it for too long.
>> >> >
>> >> > Emma
>> >> >
>> >> > "Ken Snell [MVP]" wrote:
>> >> >
>> >> >> In order for the Option Group to have a unique value for each
>> >> >> record,
>> >> >> you
>> >> >> need a field in the form's Recordsource (which means you'll need a
>> >> >> field
>> >> >> in
>> >> >> a table that is part of the form's Recordsource) where the option
>> >> >> group's
>> >> >> value can be stored. Do you have such a field in a table?
>> >> >>
>> >> >> --
>> >> >>
>> >> >> Ken Snell
>> >> >> <MS ACCESS MVP>
>> >> >>
>> >> >> "Emma" <Emma@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> >> news:DD634DE3-CC76-4FCC-A697-FA44C620BA84@xxxxxxxxxxxxxxxx
>> >> >> > The Option group needs to be unique to each record, e.g. record
>> >> >> > one
>> >> >> > I
>> >> >> > could
>> >> >> > select Foundation, then on the next record I could select Higher,
>> >> >> > third
>> >> >> > Record Foundation or higher etc, but what is happening at the
>> >> >> > moment, I
>> >> >> > select foundation on one record, and that changes every other
>> >> >> > record
>> >> >> > to
>> >> >> > be
>> >> >> > foundation, and the same happens if i select higher.
>> >> >> >
>> >> >> > The option group has values Foundation + Higher...these values
>> >> >> > have
>> >> >> > been
>> >> >> > created to do the below functions, using visual basic code.
>> >> >> >
>> >> >> > The 'foundation' option showns the value of
>> >> >> > 'GermanCourseworkMark'
>> >> >> > and 'GermanExaminationMarkF' in the 'OverallMark' box when
>> >> >> > selected.
>> >> >> >
>> >> >> > The 'Higher' option showns the value of 'GermanCourseworkMark'
>> >> >> > and
>> >> >> > 'GermanExaminationMarkH' in the 'OverallMark' box when selected.
>> >> >> >
>> >> >> > The Option group has no control source...OverallMark has control
>> >> >> > source
>> >> >> > of
>> >> >> > OverallMark
>> >> >> >
>> >> >> > I think thats everything I've implemented so far to do with this
>> >> >> > option
>> >> >> > group.
>> >> >> >
>> >> >> > Thank You!
>> >> >> >
>> >> >> > Emma
>> >> >> >
>> >> >> >
>> >> >> > "Ken Snell [MVP]" wrote:
>> >> >> >
>> >> >> >> By "Options from the Option group will not update on each
>> >> >> >> record",
>> >> >> >> what
>> >> >> >> do
>> >> >> >> you mean? Do you mean that the optioni group's "selection" isn't
>> >> >> >> changing
>> >> >> >> on
>> >> >> >> each record? It won't unless there it is bound to a field in
>> >> >> >> your
>> >> >> >> form's
>> >> >> >> record source that contains a value that the option group
>> >> >> >> recognizes
>> >> >> >> (1
>> >> >> >> or
>> >> >> >> 2, in your case).
>> >> >> >>
>> >> >> >> I had understood from your description that you were using the
>> >> >> >> Option
>> >> >> >> group
>> >> >> >> just to make a selection as to what value of data was to be
>> >> >> >> written
>> >> >> >> into
>> >> >> >> the
>> >> >> >> OverallMark textbox. My suggestion to remove the field name from
>> >> >> >> the
>> >> >> >> option
>> >> >> >> group's control source was because it appeared it was also bound
>> >> >> >> to
>> >> >> >> the
>> >> >> >> OverallMark field, as is the OverallMark textbox, and the two
>> >> >> >> controls
>> >> >> >> cannot hold the same type data in your setup from what I'm
>> >> >> >> reading.
>> >> >> >>
>> >> >> >> So, are you storing the option group's value in a field in the
>> >> >> >> form's
>> >> >> >> recordsource? or are you using it just to make a selection for
>> >> >> >> your
>> >> >> >> form
>> >> >> >> to
>> >> >> >> write data into the OverallMark textbox?
>> >> >> >> --
>> >> >> >>
>> >> >> >> Ken Snell
>> >> >> >> <MS ACCESS MVP>
>> >> >> >>
>> >> >> >>
>> >> >> >> "Emma" <Emma@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> >> >> news:33E500DA-5744-41B9-8DA3-7DDB2F0E3805@xxxxxxxxxxxxxxxx
>> >> >> >> > Hi!
>> >> >> >> > I have just tried this again, and it won't work properly,
>> >> >> >> > because
>> >> >> >> > the
>> >> >> >> > Options from the Option group will not update on each record,
>> >> >> >> > they
>> >> >> >> > just
>> >> >> >> > stay
>> >> >> >> > the same on each record. if i select 'higher' on one record,
>> >> >> >> > it
>> >> >> >> > stays
>> >> >> >> > on
>> >> >> >> > that
>> >> >> >> > for each record, although the 'OverallMark' updates as it
>> >> >> >> > should.
>> >> >> >> >
>> >> >> >> > Do you have any suggestions?
>> >> >> >> >
>> >> >> >> > Thanks,
>> >> >> >> >
>> >> >> >> > Emma
>> >> >> >> >
>> >> >> >> > "Ken Snell [MVP]" wrote:
>> >> >> >> >
>> >> >> >> >> You're welcome.
>> >> >> >> >>
>> >> >> >> >> --
>> >> >> >> >>
>> >> >> >> >> Ken Snell
>> >> >> >> >> <MS ACCESS MVP>
>> >> >> >> >>
>> >> >> >> >> "Emma" <Emma@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> >> >> >> news:4E6BC01F-51BC-428C-B223-E270F3DEA67C@xxxxxxxxxxxxxxxx
>> >> >> >> >> > Excellent! Thank you very much!!! I've been trying to solve
>> >> >> >> >> > this
>> >> >> >> >> > for
>> >> >> >> >> > hours!!
>> >> >> >> >> > Thank you again!
>> >> >> >> >> >
>> >> >> >> >> > Emma
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >> > "Ken Snell [MVP]" wrote:
>> >> >> >> >> >
>> >> >> >> >> >> If I'm understanding your setup correctly, the Control
>> >> >> >> >> >> Source
>> >> >> >> >> >> property
>> >> >> >> >> >> for
>> >> >> >> >> >> the option group should be empty. It should not be bound
>> >> >> >> >> >> to
>> >> >> >> >> >> OverallMark.
>> >> >> >> >> >>
>> >> >> >> >> >> Also, remove the
>> >> >> >> >> >> =[OverallMark]
>> >> >> >> >> >> from the On Mouse Down property for the option group.
>> >> >> >> >> >>
>> >> >> >> >> >> --
>> >> >> >> >> >>
>> >> >> >> >> >> Ken Snell
>> >> >> >> >> >> <MS ACCESS MVP>
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >> "Emma" <Emma@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> >> >> >> >> news:1565A796-7C8E-4982-B612-2020C8B55250@xxxxxxxxxxxxxxxx
>> >> >> >> >> >> >I have created an option group, with the values
>> >> >> >> >> >> >'Foundation'
>> >> >> >> >> >> >=1
>> >> >> >> >> >> >and
>> >> >> >> >> >> >'Higher' =2
>> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >> >> > The 'foundation' option showns the value of
>> >> >> >> >> >> > 'GermanCourseworkMark'
>> >> >> >> >> >> > and
>> >> >> >> >> >> > 'GermanExaminationMarkF' in the 'OverallMark' box when
>> >> >> >> >> >> > selected
>> >> >> >> >> >> >
>> >> >> >> >> >> > The 'Higher' option showns the value of
>> >> >> >> >> >> > 'GermanCourseworkMark'
>> >> >> >> >> >> > and
>> >> >> >> >> >> > 'GermanExaminationMarkH' in the 'OverallMark' box when
>> >> >> >> >> >> > selected
>> >> >> >> >> >> >
>> >> >> >> >> >> > The 'OverallMark' box control source is set to
>> >> >> >> >> >> > OverallMark,
>> >> >> >> >> >> > the
>> >> >> >> >> >> > Option
>> >> >> >> >> >> > Groups Control source likewise.
>> >> >> >> >> >> >
>> >> >> >> >> >> > On OptionGroup properites 'On Mouse Down' set to
>> >> >> >> >> >> > =[OverallMark]
>> >> >> >> >> >> >
>> >> >> >> >> >> > The Option group functions correctly, but the option box
>> >> >> >> >> >> > for
>> >> >> >> >> >> > the
>> >> >> >> >> >> > option
>> >> >> >> >> >> > chosen is not selected(doesn't have a dot in it!)
>> >> >> >> >> >> > although
>> >> >> >> >> >> > I
>> >> >> >> >> >> > have
>> >> >> >> >> >> > clicked
>> >> >> >> >> >> > it,
>> >> >> >> >> >> > the calculations are performed correctly though.
>> >> >> >> >> >> >
>> >> >> >> >> >> > How do I get the Option to be selected when I click it,
>> >> >> >> >> >> > so
>> >> >> >> >> >> > it
>> >> >> >> >> >> > has
>> >> >> >> >> >> > a
>> >> >> >> >> >> > dot
>> >> >> >> >> >> > in
>> >> >> >> >> >> > it?
>> >> >> >> >> >> >
>> >> >> >> >> >> > Thank you - if you require anymore information about my
>> >> >> >> >> >> > option
>> >> >> >> >> >> > group
>> >> >> >> >> >> > to
>> >> >> >> >> >> > solve this, then I've give it.
>> >> >> >> >> >> >
>> >> >> >> >> >> > Thank you in advance!
>> >> >> >> >> >> >
>> >> >> >> >> >> > Emma
>> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>


.

Relevant Pages

  • Re: Option Group Problem
    ... I don't think I do have a field to store the option groups value. ... want to store the sum in the OverallMark field. ... >> that when foundation or higher from the option group is selected, ...
    (microsoft.public.access.forms)
  • Re: Option Group Problem
    ... So what are you wanting to store in the table field named OverallMark -- the ... > that when foundation or higher from the option group is selected, ... >> You then mention that selecting 'Foundation' in the option group then ...
    (microsoft.public.access.forms)
  • Re: option group true/false
    ... the check boxes, as it is part of an evaluation that needs to be archived. ... in the LimitNo field of the DriverInfo table? ... As such, there is no need to store it in your table, indeed ... I have an option group on a form that has 5 choices that can be true or ...
    (microsoft.public.access.modulesdaovba)
  • Re: Need way to see which combinations of which fields equal given number
    ... first the problem is where to store the results. ... A brute force algorithmn would simply loop trough the array, ... one combination an check if this is equal to the desired sum. ... > "Frank Kabel" schreef in bericht ...
    (microsoft.public.excel.misc)
  • Re: Yes/No and default values
    ... question becomes, then, how do I store N/A? ... >Use of a boolean field goes far beyond checkboxes, ... >easy to use your option group with it, ... >> control to choose Yes), and the absence of a check mark ...
    (microsoft.public.access.gettingstarted)