assignig a choice to a frame's option buttons

[markjkubicki]

i have an frame with 3 option buttons. sometimes a record may not yet have a value for the field attached to the frame, in which case i want to assign the value 3 (the default value of a new record may be different, but of an existing record, if nothing is yet entered, 3 would be the correct choice.)



so i put in this line of code. the second half of it does return the correct value (3) (when the field value is null), but it does not assign the value to the frame; button 3 is not choosen, and the buttons remain greyed out (as if the value was null)

                .frmSinkSource.Value = Nz(DLookup("[SinkSource]", "tbeFixtureTypeDetails"), 3)

hmmmm?
with thanks in advance,
mark

[ranman256]

if the record is there but the field already is null, then the frame wont give a value.
youd have to physically set the option thru the form, or refresh the form if done behind the form in a query.

[ssanfu]

In my tests, the option button gets selected/highlighted.

I created a table "tbeFixtureTypeDetails" with a field "[SinkSource]". The table has one record - I set the field to 2 and ran the code. 2 was returned and the correct button was "selected".
Do you have the option frame bound to a field?

I then deleted the value and ran the code. 3 was entered and the correct button was again "selected".


BTW, you do not have criteria specified for the DLookup. From Help:

The DLookup function returns a single field value based on the information specified in criteria. Although criteria is an optional argument, if you don't supply a value for criteria, the DLookup function returns a random value in the domain.

You could post a copy of your dB for analysis........