Solved

Open new form at current record

Posted on 2014-11-10
1
332 Views
Last Modified: 2014-11-11
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

Open in new window


I'm get an erro. Please help
0
Comment
Question by:damixa
1 Comment
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 500 total points
ID: 40433623
you have the syntax wrong.  Try:

If Not Me.NewRecord Then
    DoCmd.OpenForm "frm_qry_tbl_main_edit",,, "[ID] = " & me.ID
End If
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Dynamically Reorder List Box 4 37
Delete QueryDef IF it Exists: Access VBA 5 33
Dlookup MSACCESS 5 25
Need help constructing a conditional update query 16 42
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question