Open DE form based on value "Complaint" in field in other form (1 Viewer)

[cft]

I am having difficulty with a form that is capturing info on correspondence received from customers. I want to have a seperate form pop-up when the "Correspondence Type" field is populated with the term "Complaint" from a drop-down list in a combo box. The form "pops" but it pops regardless of the selection in the combobox. How do I get it to be selective? Thanks for any input provided.

 

[David R]

If(Me.ComboBox.Value = "Complaint" Then Docmd.OpenForm "ComplaintForm",,,"[IDField] = " & Me.IDFieldControl,,acDialog

This should go in the AfterUpdate event of the combo box. Change field/form names as appropriate.

 

[cft]

This worked great! Thanks! I have one issue that I am working to overcome, and your advise again would be appreciated. When the form "FrmComplaintData" opens, it is in datasheet view not form view. I keep trying to correct, but get the same datasheet view every time when it opens.

 

[cft]

Got it! Took off the acDialogue and it works fine! Thanks for getting me over this hurdle!