this question has been asked a lot BUT recently i read LSMConsulting's solution on how to show or hide the command button and i thought it was really cool but when i tried it i couldn't get it to work.
here's his solution http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23632241.html#a39456218
This is working correctly for continuous forms. A continuous form is simply the SAME form repeated over and over again with different data. The controls are all the SAME control, and unless those controls are BOUND to a ControlSource, they will behave as a group.
The only way to do this is to add a Field to the table that's driving your continuous form, and use that field to show/hide your button. For example, add a field named "bShow" and set the Default value to False. Then, when a user enters a note, set this value to True.
In the Current event of the form, you can do this:
Me.YourNotesButton.Visible = Me.bShow
Or you may be able to use Conditional Formatting to do this ... use the Expression argument.
i'm refering to the Current event solution.
when my current record in my continuous form is Me.bShow = True, then ALL the command buttons in the continuous button is suddenly shown. then when i click to another record, ALL the command buttons are hidden.
to me, i think this is the expect behaviour based on all my readings.
because like what one of the MVPs said, even though in a continuous form with 20 records there might look like there are 20 command buttons, there is only 1 actually. so if you hide it, you hide all.
so am i implementing LSMConsulting's solution correctly or is there something i'm doing wrong that is cause ALL the controls to be shown / hidden instead of one? thanks guys!! = ))