Pop Up Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open different form based on combo box selection 2
Open 2nd form in Add Mode with a value taken from 1st form 5
Why are my fields protected? 12
Pop up form - field not updated 2
Open Filtered Form thru Logon Form 1
OPen Form B from Form A with related records 6
Accessing Data From Multiple Forms/Tables 5
Pop-up form that creates record that links 1:1 to main form 0

Back
Top