frame with radio buttons 1

[GShen]

Hi, I have a select query with multiple tables joining which are populating a form. I added an frame with 3 radio buttons. There is a table in the select which has the type which can be either a 0,1 or 2, hence the 3 buttons. I have the frame on the form as an unbound field. I can click on the frame obviously and change the radio buttons which I will kick off a stored procedure (after update) to update the assoicated field and refresh the screen. I can do all of that. Howeve, how can I display the value of the field in the frame from the select? If I set it to the control, then I can't update the field obviously. I tried DEFAULT and I tried ON OPEN to set the frame to the field but both do not work. This is a continues form by the way. There has to be a way of getting around this.
Thanks in advance

Remember when... everything worked and there was a reason for it?

 

[GShen]

Strange. When I type it in, the intellisense recognizes it and gives me the syntax. In any case, is it more efficient to do it this way or just called the SP to do the update. We call sp's to do this all the time.

Remember when... everything worked and there was a reason for it?

 

[PWise]

it is more efficient to have a function and call the function then to have and pass the sp name then to retype all this every time

back to the OP does your form work the way you want now

 

[GShen]

I would when you state OP, you mean option group. Yes, it seems to work correctly when I click on the option it goes to the correct event for that option. As far as that zero goes, what do I put in there if there is nothing to return? As with this procedure. I just want it to update the field with the new data and requery the form.

Remember when... everything worked and there was a reason for it?

 

[GShen]

PWise,
I got it working by calling the sp. I wanted to make sure it was working before I put in the function. It works great! The only problem I have is that everytime I requery the form, it makes the option group bold. It is really wierd. Everytime I click on it, it gets darker and darker and then some green and starts coming out and it gets fuzzier and fuzzier. If I close the form and reopen, all is well again. Just wierd.

Remember when... everything worked and there was a reason for it?

 

[PWise]

OP == orignal post
As far as the zero as a mattrer of habit i end all my Sp with return
if you dont you dont need th zero about the fuzzy fome beats me

 

[GShen]

Ok, I am burnt OP, Not OG. ugh! I will try the function tomorrow. Have to fix something else. The fuzzy thing is the wierdest thing I have ever seen. However, this is the 1st form I have ever updated using the mouse down on a form which is not updateble. Could be another Bill Gates bugger. Thanks for all your help. If I got stuck with the function or I figure out the fuzzy thing, I will ping you back.

Remember when... everything worked and there was a reason for it?

 

[GShen]

Hey PWis,
I ended up removing it. I could not get rid of the fields highlighting after clicking on the fields until I rid of the object field. I do however, put I will try and put in the function you gave me. That will save time in future databases so all we have to do is put that in once and then call it and like you said, without putting in all the needless code everytime.
Thanks. I will let you know if I have any problems.

Remember when... everything worked and there was a reason for it?