I've got a little problem, I was wondering if you might be able to give me a hand...? So here it is:
I've implemented a form which pops up on start-up. That has a list box which works as a basic list of any assignments due within the week. The only thing is what I want to do from there is be able to double-click an item on the list and go to the relevant record to see the full set of details, the list box only provides a brief summary. I'm having trouble specifying an event on a single element of a list box rather than the whole list box object itself. Clearly I'm approaching this entirely the wrong way. Any ideas?
I don't follow what you mean by single select. The listbox has fours columns and a variable amount of records depending on the results of the query. One of those records are active or have focus at any one time.
Thanks for the link btw. I gave it a go but it asks me for the assignmentID parameter when I double click. This is the procedure I've written:
Private Sub lstOneWeek_Click()
DoCmd.OpenForm "frmAssignment", acNormal, , "frmAssignment.assignmentID = " + Me.lstOneWeek, acFormReadOnly, acDialog
- frmAssignment is the form which contains a record with details for each individual assignment (the form I want to open)
- assignmentID is the primary key of tblAssignment which frmAssignment and qryOneWeekLeft (the summary listbox's data source) is based on
- lstOneWeek is the summary listbox (I want to double click one item from this list to initiate the opening of the form with full details)