OK guys I have a Conintuous form which I am allocating monies in /status
THe button i have will mark the record as settled (with a date stamp)
However what I wanted to do is have a drop down box with Outstanding (default) part paid and settled
now below makes the button appear/disappear for all records and not just the one I am on - its bound to be something simple (me.settlement is the name of the button)
pointers would be appricated
G
code follows
Private Sub status1_AfterUpdate()
If Me.status1 = "settled" Then Me.settlement.Visible = True
If Me.status1 = "Oustanding" Then Me.settlement.Visible = False
If Me.status1 = "PartPaid" Then Me.settlement.Visible = False
Refresh
End Sub
THe button i have will mark the record as settled (with a date stamp)
However what I wanted to do is have a drop down box with Outstanding (default) part paid and settled
now below makes the button appear/disappear for all records and not just the one I am on - its bound to be something simple (me.settlement is the name of the button)
pointers would be appricated
G
code follows
Private Sub status1_AfterUpdate()
If Me.status1 = "settled" Then Me.settlement.Visible = True
If Me.status1 = "Oustanding" Then Me.settlement.Visible = False
If Me.status1 = "PartPaid" Then Me.settlement.Visible = False
Refresh
End Sub