Form not loading right

[Linda RQ]

Access 2003. I have a data entry form. I have an option group set up so
the user can select the active patients or the inactive patients. Right now
when I open the form, the radio button for active patients is selected but
the inactive patients are actually showing. I have to click the inactive
radio button then re-click the active radio button for the active patients
to show. The option group is located in my form header. What's going on?
I think I need to do something with the on load property of the form? Right
now I have a macro to maximize on load. I looked at the other macro's but I
don't know if I am on the right track or not.

Do you need any other info to help?


Thanks,
Linda

 

[Arvin Meyer [MVP]]

I'm not sure, but if you've designed it correctly, you should have code in
your option group that changes the recordsource of the form based on the
radio button selected. All you need to do is to take the code from the
Active Patients, and use that as the recordsource of the form.