I don't have a lot of programming experience (apart from google searching everything and a bit in Crystal) but Access just throws me!
I'm trying to link a record from a report to the same record in the form.
I have been looking in multiple forums trying to find a fix and can't seem to duplicate it correctly.
The most recent one I've tried is:
Expand|Select|Wrap|Line Numbers
- Private Sub Description_Click()
- Dim EntityName As String
- Dim Docname As String
- Docname = "frmDelivery Details"
- Filtername = "qryDelivery Details"
- strWhere = "[frmDelivery Details].[DD_ID] = 'Me.DD_ID'"
- DoCmd.OpenForm Docname, acNormal, Filtername, strWhere
- End Sub
Both the form and the report are based on qryDelivery Details. Does that need to be linked in somehow?
I have attached the database (apologies if there are any other bad practices in there...)and would be very appreciative of any help!