Can't get "detail" form to open up with the right ID number

RSW

Registered User.
Local time
Today, 13:25
Joined
May 9, 2006
Messages
178
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:

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 :)
 
Is the Data Entry property of that form Yes?
 
  • Like
Reactions: RSW
Not anymore! Thanks a million! :D
 
No problem; and I'm not greedy...a couple hundred thousand will do. :p
 

Users who are viewing this thread

Back
Top Bottom