troubleshooting Question

Open new form at current record

Avatar of damixa
damixaFlag for Denmark asked on
Microsoft AccessVisual Basic Classic
1 Comment1 Solution403 ViewsLast Modified:
Hi,
I am looking for a bit of help

I have a form in datasheet view named "frm_qry_peding_records" when I click on "ID" i want to go to another form "frm_qry_tbl_main_edit" and open the record. Here is the query I tried

If Not Me.NewRecord Then
DoCmd.OpenForm "frm_qry_tbl_main_edit",,, where Forms.frm_qry_tbl_main_edit.ID = me.ID
End If

I'm get an erro. Please help
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros