Murray Brown
asked on
Access - Get ID of Subform
Hi
I am using the following code to get the selected ID in the subform shown in the image and open another form with this ID. The first
part works fine but for some reason the "Invoices" form is not opening at that ID
I am using the following code to get the selected ID in the subform shown in the image and open another form with this ID. The first
part works fine but for some reason the "Invoices" form is not opening at that ID
Dim oID As Long
oID = Me.Invoices_Summary.Form!ID
'The following line does not work properly
DoCmd.OpenForm "Invoices", acNormal, , , acFormPropertySettings, acWindowNormal, oID
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Gustav
also try this
Form_Invoices.ID