Link to home
Start Free TrialLog in
Avatar of Richard
Richard

asked on

access make one checkbox invisible if another is checked

I attach dtabase
go to form
go to tab RHK. see check box completion checked by rhk
go to tab Karan- see check box completion checked by karan

what i want is that when the rhk check box is checked then the karan checkbox is invisble.
this works but you have to go out of the form and back for it to register.
it is I think a refresh issue but I cannot quite do it.

practice-completionDatabase.mdb
ASKER CERTIFIED SOLUTION
Avatar of Bill Ross
Bill Ross
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Richard
Richard

ASKER

thanks will try

what is the difference between refresh and requery please??

Hi,

Refresh applies the the screen only and updates any pending screen changes.  Requery repulls the data.  Refresh will not work here since the screen changes have not been saved back to the DB.  If you want the latest data to match the screen then it's good practice save the data and requery the form just to be sure.  Multi user issues are handled as well.

Regards,

Bill
Avatar of Flyster
Is this what you are looking for?

Flyster
practice-completionDatabase.mdb
Avatar of Richard

ASKER

Flyster, am tempted to give bill denver the points becuase first to reply.
however when i looked at your solution which appears to work, it does not use save record and requery.

can you explain what you did and how it works compared to mine.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Richard

ASKER

Thanks that helps, what exactly does the on focus event do, if i might ask.

When you click or tab to a control, and that control is "highlighted", that control is said to have focus. Any code in the on focus event will fire once the control is selected.
Hi,

Flyster's method is fine and fast for screen updates.  I prefer to update the database but bother methods are fine.

Also, do what you want with the points.

Regards,

Bill
Avatar of Richard

ASKER

thanks guys for your help and solutions and i feel i have learned something from both your involvement.