Split Form Question

[data808]

I was wondering if there was a way to click on a record in a split form that will take me to another form that shows the record I clicked on in the split form? In other words, all the records in the split form are like links and when I click on one of them, it opens up a regular form that shows that record that I clicked on. Is that possible?

[orange]

There is a sample here of opening a form from a record in a form (not split form).

[data808]

Is all the code in that zip file you provided? I already have a filter system on my split form to find what I'm searching for. I just need to apply the part where you can click on the record to see it in a regular dynaset form for editing. My splitform is a snapshot thats why.

[June7]

The split form DblClick event works for me.

[data808]

Thanks June7 but how does it know which record to open in the next form? Does it just know that whatever record I double click in the datasheet of the split form, it will know to open that record in the next form that opens up? I'm confused to how it works.

[June7]

Need code in the DblClick event, like:

DoCmd.OpenForm "formname", , , "ID=" & Me!ID

The click must be on the record selector on left side of the form.

[data808]

This is the code I am trying to use in the double click event of the split form called Counter Citation Number.

DoCmd.OpenForm "Counter Log", , , "RefNum=" & Me![Ref Num]

Right now when I am in my split form which is called Counter Citation Number, I double click in the record selector, it will have a little "Enter Parameter Value" window. I enter the reference number that I want (reference number field is my primary key) and then the Counter Log form opens but not on the record I wanted. I'm not sure if the names of the reference fields are different is what is causing it to not work but the name of the field in the split form for reference number is "Ref Num" and the name in the Counter Log form is "txtRefNum". Other than that, I do not know why this is not working. Please help.

Update: I Just tried renaming the field name in the Counter Log form to match the name in the split form. I still get the same results. If I can get this to work that would be so cool. It would save a lot of time to pull up records to edit.

[June7]

Cannot replicate the issue. Would have to review your db.

[data808]

Is it working the way its supposed to except for the part where its just not pulling up the record that I want? What I mean is that is the Enter Parameter Value window supposed to pop up like that? If so, what am I supposed to type in that box?

Please explain this line of code so I know what this part is doing: "ID=" & Me!ID

DoCmd.OpenForm "formname", , , "ID=" & Me!ID

I know I have to obviously change the "formname" to the form that I want to open.

[June7]

"ID=" & Me!ID is example of filter criteria passed to the opening form.

Should not be a parameter popup.

[data808]

Well this sounded better than the way I decided to pull up a record but I just don't know how to get it to work. I'll just use the other way for now. Thanks for all the help June7. You are a lifesaver.