how to open anothor form keep the record set (1 Viewer)

sspreyer

Registered User.
Local time
Today, 03:43
Joined
Nov 18, 2013
Messages
243
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

View attachment test file.accdb
thanks in advance

shane
 

burrina

Registered User.
Local time
Today, 05:43
Joined
May 10, 2014
Messages
974
Is this form not using the subforms Primary Key as a Link? Is the form bound? More Details on this popup.
 

sspreyer

Registered User.
Local time
Today, 03:43
Joined
Nov 18, 2013
Messages
243
yes it using primary key from the sub form to make the link it bound to tblplantservice

see my attachment

cheers

shane
 

GinaWhipp

AWF VIP
Local time
Today, 06:43
Joined
Jun 21, 2011
Messages
5,627
Okay, first issue I see is you need to change ServiceID to ImpPlantItemID in your embedded macro. See if that fixes your issue.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom