DBL Click Form - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

DBL Click Form

Anna Lad

5 years ago

Hi! I just joined & this is my first question. I don't see the answer anywhere so here goes:

- I want to DOUBLE CLICK a record in a ListBox after Searching for it with a SearchBox. And have the selected RecordForm open up.

- Timestamp 9:07 in Computer Learning Zone Video : "Microsoft Access Search Form - MS Access Search For Record by TextBox"

- Followed above video to make the searchbox and searchlist and it worked perfectly. However I need the additional functionality described at 9:07 in the video. (it says that "Developer Level 9" tells you how to do the double click + specific record, but that's not out yet).

Where I'm at:
- I can get the RecordForm to open up on a double click, but it opens to entry #1, not the specific Record I clicked.

Example Scenario of Success:
(Richard uses "customers", I have "projects".)

SearchBox: *User types Bubble Gum Project, hits Enter*

SearchList: *returns 3 records: Bubble Gum Project A, Bubble Gum Project B, Bubble Gum Project C*

*User Double Clicks on 'Bubble Gum Project C' in the ListBox. The ProjectForm opens up to the 'Bubble Gum Project C' record.*

	Alex Hedley @Reply 5 years ago
Access Developer Level 9?

	Alex Hedley @Reply 5 years ago
What code are you using in your double click event?

Anna Lad OP @Reply

5 years ago

Thank you for the link to developer 9! When I looked for it it said it wasn't out yet.

Here is the VBA, which I converted from the Macro option. This code gets the 'ProjectFTest' form to open, but not to the selected record I clicked in the ListBox.

Private Sub SearchList_DblClick (Cancel As Integer)
On Error GoTo SearchList_DblClick_Err

    DoCmd.OpenForm "ProjectFTest", acNormal, "", "", , acNormal

SearchList_DblClick_Exit:
    Exit Sub

SearchList_DblClick_Err:
    MsgBox Error$
    Resume SearchList_DblClick_Exit

End Sub.

	Anna Lad OP @Reply 5 years ago
* SCRATCH THAT ** ^^^^ I just tried to run it again after converting it into VBA and now it doesn't work.... :/ Sorry! It worked in the macros. The macro itself is only a "Open Form". I don't know where to go from there.

	Adam Schwanz @Reply 5 years ago
Yea you probably might have the wrong ID listed or a different field bound in the listbox. This is one that i use for parts you could substitute your fields in for, PartsList being the name of the list box If IsNull(PartList) Then Exit Sub Else DoCmd.OpenForm "PartsF", , , "PartID= " & PartList End If

	Richard Rost @Reply 5 years ago
I would recommend Access Developer 1. Not only does it cover that specific example of how to open a form based on the value on another form, but it gives you a good solid background for VBA if you haven't done much programming in Access.

	Anna Lad OP @Reply 5 years ago
It works, holy cow!! Thank you both!!

	Alex Hedley @Reply 5 years ago
@Anna where did it say D9 wasn't out yet?

	Richard Rost @Reply 5 years ago
Yeah, D9 was released in 2018. :)

	Anna Lad OP @Reply 5 years ago
@Alex I clicked on the link to access D8 from the youtube video (title above). Then when I clicked the > to D9 it said "coming soon!" as if it wasn't already out.

	Alex Hedley @Reply 5 years ago
@Rich you need to fix D8 links at the top.

	Richard Rost @Reply 5 years ago
Done. Thank you for letting me know about that. I'm surprised in 3 years nobody has mentioned it. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View