Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 735
  • Last Modified:

Link to open form in Access not working

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
btgtech
Asked:
btgtech
  • 2
2 Solutions
 
TheNauticanCommented:
Try This

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

Open in new window

0
 
PatHartmanCommented:
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
 
clarkscottCommented:
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
 
PatHartmanCommented:
Correct.  The .value property isn't necessary since that is the default property of the control.  But, that isn't causing the problem.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now