Button on a continuous form.

[SpiritedAway]

Hi,

I have a continuous form with a button 'Cmd1' & a textbox 'txtMail' which is set to visible no.

When the user clicks Cmd1 - then txtMail becomes visible.

I can do it using vba on the buttons click event but when it executes txtMail for all the records become visible.

How do I use a button's click event on the form's current record - Private Sub Form_Current() so that when the user clicks Cmd1 on the current record only txtMail for that record becomes visible.

Any help would be appreciated. I'm using Access 2007.

 

[David R]

.Visible is tricky with Continuous Forms, but I think you can set foreground/background color in Form_Current to accomplish approximately the same thing, and it will only affect the current record.

Someone else may have a better idea.

 

[RainLover]

Look at Conditional formatting.

You will have do some searching but I think that this is your solution.

 

[David R]

I don't think Conditional Formatting allows you to set the .Visible property directly. http://www.dbforums.com/microsoft-a...ous-form-making-button-visible-invisible.html

It'll have to be VBA I'm afraid.

 

[SpiritedAway]

Just out of interest how would you write a button's click event into a form's current record in vba?

Private Sub Form_Current()

Cmd1_Click
Me.txtMail.Visible = True

End Sub

Is there a way of doing that?

 

[RainLover]

To start, change the name of the Button to something more meaningful.

Then go to the properties in design and find the On Click Event.

 

[RainLover]

I don't think Conditional Formatting allows you to set the .Visible property directly. http://www.dbforums.com/microsoft-a...ous-form-making-button-visible-invisible.html

It'll have to be VBA I'm afraid.

You could use Conditional Formatting to change back colors etc to give the appearance that it is visible or not.

This would be better if written as a Sub and call the Sub when needed.

 

[David R]

A click Event is different from a current record Event. Each one can be called separately for different reasons. See here: http://office.microsoft.com/en-us/access-help/order-of-events-for-database-objects-HP005186761.aspx

In your case the Click event will vis/invis the field right now, while Form_Current would allow you to have the field come visible every time you loaded it (say, if the field were not blank).

 

[Dewi]

controls on a continuous form will perform the same operation regardless of which record they are on...what you need to do is build in to the on-click event a conditional email event...i.e email record with ID=Me!ID.....it will only see one id and that will be the current record......maybe?????

 

[Galaxiom]

I use textboxes made to look like buttons on Continuous Forms. Set their SpecialEffect to Raised. Put their "caption" in the Default property or use a ControlSource = "somestring"

Conditional Formatting can be used to Enable/Disable the textbox based on expressions in the conditions. The forecolor and backcolor can also be changed to make the textbox grey out like a disabled button.

In the on click event I change the SpecialEffect from Raised to Lowered and back after a short pause. This provides feedback that simulates the button being pressed.

It should make all the "buttons" on the Continuous Form appear to be pressed and this is what happened in Access 2007. However I recently found in Access 2010 on a newer computer that only the one button appears to move if the pause time is short enough. This is apparently only a fortuitous artefact of the display.

Take the focus to another control at the end of the event procedure to stop the textbox getting its displayed value highlighted.

 

[jdraw]

Here is a video (demo is in Acc2013) on adding a hyperlink on a continuous form. Clicking the hyperlink (analogous to clicking a button) invokes some action.
Not exactly what you asked, but may apply.

Access 2013 40 - Adding A Button To A Datasheet