Help with Button please! 1

[DarkOne72]

Hello,

I know this will probably be really basic but how can I accomplish this please?

I have a button on a form that when clicked it will reveal a hidden label or text box and store that information for that record (saying something like "Confirmed"

Thanks for your help...

btw I am using Access 2010

 

[Triacona]

Try this..

Private Sub Enable_Click()
'Enable button
txtStartDate.Enabled = True
Msgbox "Confirmed", vbExclamation, "Confirmation"
End Sub

txtStartDate is my text box, subs for.
Hope this helps []

Thank you,

Kind regards

Triacona

 

[DarkOne72]

Thank you for the prompt response; I don't want a msg box to appear saying confirmed I need it to show up on the form next to a particular item showing that button was clicked for its function.

Thanks..

 

[Triacona]

Hi,

To update your record set, create an update query...

[blue]Private Sub[/blue] Enable_Click()

[blue]Dim[/blue] stDocname [blue]As String[/blue]
    stDocname = "[i]update query here[/i]"
    
    txtStartDate.Enabled = True

    DoCmd.OpenQuery stDocname, acNormal, acEdit
    

[blue]End Sub[/blue]

Thank you,

Kind regards

Triacona

 

[MazeWorX]

assuming your label is called lblInfo

lblInfo.Caption = "Confirmed"

and store that information for that record

store what information where?







HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

 

[DarkOne72]

Well the form is tied to a table and for each record they have an option to click on a certain button. If they click this button I want the text field to show confirmed and then save the record (since that is a field in the table for being confirmed).

Thanks...

 

[DarkOne72]

I got it to work the way I needed to from using MazeWorx suggesstion; thank you all for you assistance it works like a charm.