Combo Box After update event

[siCIVIC1986]

Hi All

I wondered if anybody has any good advice out there regarding forms.

I am currently designing a bespoke database entry form and have come up to a point where I need to be able to flag a record if it is "INACTIVE" or "ACTIVE"

I would like it so that if the user selects "INACTIVE" from the drop down a prompt will pop up with a text box that needs to be filled in with the reason why it is "INACTIVE" and the user cannot continue or select the "INACTIVE" option unless this reason is filled in.

I have created a form that links to the reason why it is "INACTIVE" but I cant for the life of me think what to do next!

(Could be Friday afternoon madness kicking in!)

Would appreciate your help

Thanks

Simon Knott

 

[vbaInet]

* Make the pop-up form Modal... look up Modal and Popup properties.
* Cancel the Unload event of the form IF the textbox is empty... test for Null and ""

 

[siCIVIC1986]

* Make the pop-up form Modal... look up Modal and Popup properties.
* Cancel the Unload event of the form IF the textbox is empty... test for Null and ""

Hi thanks For this, Just to let you know I got it to work.

I made the form type modal and on the combo box that I wanted to control the prompt I put the following in the AfterUpdate command:

Public Sub cboStatus_AfterUpdate()
    If Me.cboStatus = "INACTIVE" Then
    DoCmd.OpenForm ("Prompt")
    End If
End Sub

Thanks for your help!

 

[vbaInet]

Good job!

 

[siCIVIC1986]

Good job!

It obviously was a case of Friday afternoon madness! :banghead:

Thanks Again.

 

[vbaInet]

You were itching to go home