Adding option buttons

[raskew]

John/Teiben

Understand that code can initially be intimidating, but you're already using code in this problem since it sure doesn't lend itself to a query solution.

There has to be a point when one jumps in and tests the waters. If not now, when?

Bob

 

[jjturner]

Everyone, I'm in this one deep, so I'd like to see it through.

teiben, Bob's code works fine, but if you wanted to further investigate the strange results you're getting, do the following:

1) look on your 'Data' tab on the Properties box for one of your frames - the first property on that tab is 'ControlSource'. Check what the name of that field is.

2) Now, go to the table that your form is based on and go to design view. Check what the DataType is for the field name that was in the ControlSource property. If it's Text it has to be changed to a Number datatype - OR -

3) find an alternate field that is a Number that you can use as the ControlSource for the frame

4) Once your frames are set to Number fields your expression will work fine

And Bob, I agree wholeheartedly - one cannot begin to develop db's professionally w/o knowing how to code.

Any way we can do it, let's try and get teiben up and running here!

Cheers Again,
John

 

[teiben]

THe fields are Long Integer and please lose no sleep, I'm by far a "developer", and yes I'm not very good at coding, but not for a lack of not trying.

 

[teiben]

jjturner,

I figured it out! HARRRRRRRRRRRRRRRRRRAHH

WHen I went back in the table to doulbe check what you were talking about (field types), results 1 thru 6 were coded as numbers, long intergers; but I must have gotten interupted and didn't finish changing the rest of them. On the form, I was trying to code on result15, & 16, so it was wasn't working. Thank you so much for the help. Rest assured, it I ever get that message again, I'll know that I screwed up on my datatypes.

 

[jjturner]

All's Well that Ends Well!

Peace, Out

 

[raskew]

You gotta be an Ike Turner fan to "Peace Out" on that fiasco!

Bob

 

[jjturner]

What can I say, I'm nuts I guess ...
And actually, more of a Tina Turner fan!

Oh, and should our paths cross again in the future, I could only do the gentlemanly thing and let you do all the 'splaining

Big Wheels Keep On Turnin'