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

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

Is this form not using the subforms Primary Key as a Link? Is the form bound? More Details on this popup.

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

see my attachment

cheers

shane

Okay, first issue I see is you need to change ServiceID to ImpPlantItemID in your embedded macro. See if that fixes your issue.

Thanks again Gina it worked!!

Shane

GREAT and you're welcome!