I have an "overview" continuous form that lists summary information for some records. Alongside each record is a "detail" button, the Build Event code for which is:
Clicking the button DOES bring up the F_Detail form.
Switching to Design View at that point and checking form properties DOES show a Filter of, for example, [ID]=14.
But the problem is, F_Detail does not come up with the preexisting data for ID 14. It comes up just as if someone was entering a new record.
I have done this EXACT thing on databases in the past. I have no idea why the relevant data won't appear in F_Detail when I bring it up that way. Does anyone have any ideas?
Note: The F_Detail form DOES work perfectly if someone uses it to enter a new record. But I think it should work for viewing/editing an already existing record as well.
Thanks in advance for any assistance anyone can provide
Code:
stDocName = "F_Detail"
stLinkCriteria = "[ID]=" & Me![ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Clicking the button DOES bring up the F_Detail form.
Switching to Design View at that point and checking form properties DOES show a Filter of, for example, [ID]=14.
But the problem is, F_Detail does not come up with the preexisting data for ID 14. It comes up just as if someone was entering a new record.
I have done this EXACT thing on databases in the past. I have no idea why the relevant data won't appear in F_Detail when I bring it up that way. Does anyone have any ideas?
Note: The F_Detail form DOES work perfectly if someone uses it to enter a new record. But I think it should work for viewing/editing an already existing record as well.
Thanks in advance for any assistance anyone can provide