Access World Forums

Access World Forums (https://www.access-programmers.co.uk/forums/index.php)
-   General (https://www.access-programmers.co.uk/forums/forumdisplay.php?f=6)
-   -   [SOLVED] how to open anothor form keep the record set (https://www.access-programmers.co.uk/forums/showthread.php?t=266289)

sspreyer 06-30-2014 06:49 AM

how to open anothor form keep the record set
 
1 Attachment(s)
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

Attachment 54453
thanks in advance

shane

burrina 06-30-2014 07:30 AM

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.

sspreyer 06-30-2014 08:22 AM

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

GinaWhipp 06-30-2014 01:50 PM

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.

sspreyer 07-01-2014 11:50 PM

Re: how to open anothor form keep the record set
 
Thanks again Gina it worked!!:):)

Shane

GinaWhipp 07-02-2014 04:32 AM

Re: how to open anothor form keep the record set
 
GREAT and you're welcome!


All times are GMT -8. The time now is 05:28 PM.

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