Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-14-2017, 12:49 PM   #1
ry-mac
Newly Registered User
 
Join Date: Jan 2017
Posts: 2
Thanks: 1
Thanked 0 Times in 0 Posts
ry-mac is on a distinguished road
Opening specific form record from datasheet hyperlink for (New) Record

I found out how to open a form record from a datasheet hyperlink from this post: --https://access-programmers.co.uk/forums/showthread.php?t=291232--

It Works perfectly!

I want to add to that post question by adding to the original Macro allowing the user to click on "(New)" in the subform to be able to open the same form to add a new record.

After that I would assume that I'd need to be able to refresh the data on the original form and subform.

I tried to add a pic, but I don't have enough post yet (this is my 2nd).
Attached Images
File Type: jpg Macro.JPG (22.4 KB, 260 views)

ry-mac is offline   Reply With Quote
Old 01-14-2017, 01:37 PM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,120
Thanks: 13
Thanked 4,078 Times in 4,013 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Opening specific form record from datasheet hyperlink for (New) Record

Not clear on what you're asking. You can delete the where condition and change the data mode to open the form to a new record.
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Reply

Tags
datasheet , hyperlink , macro , refresh , subform

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening specific form fecord from datasheet hyperlink pavle989 Forms 5 12-30-2016 08:45 AM
How to hyperlink from query to specific record in a specific form chaconne Forms 3 07-24-2013 11:44 AM
Report Hyperlink to specific record in a form Izzygrace3 Reports 2 11-08-2012 09:56 AM
Hyperlink to a specific record in a form Winnie General 0 06-19-2003 12:44 AM
Opening a datasheet with the cursor at a specific record Essendon Queries 1 11-03-2001 01:16 AM




All times are GMT -8. The time now is 07:48 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World