Hello,

I have an overall complaint form. I also have a form for contact
information. When the user clicks on a label I've created the contact info
pops up just fine. What I'm having trouble figuring out is if there are no
records in the contact that have the ComplaintID and TaskID (these are my
unique values), how do I get it to open a new record with those IDs already
populated. Here is my code to open the contact form:
Dim ComID As Long, TaID As Long
ComID = Me.ComplaintID.Value
TaID = Me.TaskID.Value

DoCmd.OpenForm "frmContact", acNormal, , "ComplaintID = " & ComID & " And
TaskID = " & TaID & ""

Any Suggestions?