Solved

Link to open form in Access not working

Posted on 2014-02-14
4
707 Views
Last Modified: 2014-02-25
I have an Access form where I have two Hyperlinks.

1. The first link is to the Quote page and it works fine.
2, The second link is to another Entry page. I copied the first link and changed the code to call the Entry Page.  It brings up the correct page but it does not bring up the record identified.  It opens the form as new.

below is the event procedure line I am using.
If you look at the filter on the Entry page, the filter is being sent to the new page correctly.

DoCmd.OpenForm "frmEngineeringEntry", acNormal, , "[QuoteID]=" & Me.[QuoteID].Value, acFormEdit, acWindowNormal

Thoughts?
0
Comment
Question by:btgtech
  • 2
4 Comments
 
LVL 8

Expert Comment

by:TheNautican
ID: 39860743
Try This

DoCmd.OpenForm "frmEngineeringEntry", acNormal, , "[QuoteID]='" & Me.[QuoteID].Value & "'", acFormEdit, acWindowNormal

Open in new window

0
 
LVL 35

Assisted Solution

by:PatHartman
PatHartman earned 120 total points
ID: 39860872
Check the properties on the Data tab of the form.  It sounds like DataEntry is set to Yes.  Setting the DataEntry property to Yes tells the form to open to a new record prepared for data entry.
0
 
LVL 20

Accepted Solution

by:
clarkscott earned 120 total points
ID: 39862611
I don't think you need the ".value" part of you "Me.[QuoteID].Value".  I've used this code a million times and simply used = me.quoteID.

Scott C
0
 
LVL 35

Expert Comment

by:PatHartman
ID: 39862945
Correct.  The .value property isn't necessary since that is the default property of the control.  But, that isn't causing the problem.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
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.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

832 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