Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-30-2014, 06:49 AM   #1
sspreyer
Newly Registered User
 
Join Date: Nov 2013
Location: England Stanford-le-hope ,Essex
Posts: 243
Thanks: 66
Thanked 0 Times in 0 Posts
sspreyer is on a distinguished road
how to open anothor form keep the record set

hi
all

I have three tables see below

tblplantitem
tblplantgroup
tblplantservice


so I have frm called frmplant which holds the plantgroupname I.E plant type (airblow,leads) then I have subform call plantitemtblsubform which
holds the plant item serial number, value ,service date which works great now my problem I have command buttom on subformplantitemsubform then opens form call frmpopupPlantService this opens to show plantitem service history but when I add a record then save close then click the same plant item to open form frmpopupPlantService show no sevice history even when I just entered

I have a sample data base to explain better

sorry if its hard to understand so I hope the sample is clear

test file.accdb
thanks in advance

shane

sspreyer is offline   Reply With Quote
Old 06-30-2014, 07:30 AM   #2
burrina
Newly Registered User
 
Join Date: May 2014
Posts: 974
Thanks: 67
Thanked 151 Times in 133 Posts
burrina will become famous soon enough
Re: how to open anothor form keep the record set

Is this form not using the subforms Primary Key as a Link? Is the form bound? More Details on this popup.
burrina is offline   Reply With Quote
Old 06-30-2014, 08:22 AM   #3
sspreyer
Newly Registered User
 
Join Date: Nov 2013
Location: England Stanford-le-hope ,Essex
Posts: 243
Thanks: 66
Thanked 0 Times in 0 Posts
sspreyer is on a distinguished road
Re: how to open anothor form keep the record set

yes it using primary key from the sub form to make the link it bound to tblplantservice

see my attachment

cheers

shane

sspreyer is offline   Reply With Quote
Old 06-30-2014, 01:50 PM   #4
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,369
Thanks: 21
Thanked 893 Times in 878 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: how to open anothor form keep the record set

Okay, first issue I see is you need to change ServiceID to ImpPlantItemID in your embedded macro. See if that fixes your issue.
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
The Following User Says Thank You to GinaWhipp For This Useful Post:
sspreyer (07-01-2014)
Old 07-01-2014, 11:50 PM   #5
sspreyer
Newly Registered User
 
Join Date: Nov 2013
Location: England Stanford-le-hope ,Essex
Posts: 243
Thanks: 66
Thanked 0 Times in 0 Posts
sspreyer is on a distinguished road
Smile Re: how to open anothor form keep the record set

Thanks again Gina it worked!!

Shane
sspreyer is offline   Reply With Quote
Old 07-02-2014, 04:32 AM   #6
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,369
Thanks: 21
Thanked 893 Times in 878 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: how to open anothor form keep the record set

GREAT and you're welcome!

__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


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

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
form to edit a record, when I open a record the combo boxes do not populate? brainox Forms 1 05-30-2013 04:40 PM
[SOLVED] Open a Second Form & Select a Record to Open Another Form dgaletar Forms 10 02-15-2013 09:56 AM
open main form on a record where the last record in the subform was edited priyankkathiriya Forms 3 06-26-2011 12:48 AM
Open specific report record based on form record values dbaldwin Modules & VBA 5 04-26-2011 08:54 AM




All times are GMT -8. The time now is 01:10 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