MaxPower
Newbie
Joined: 13 Jul 2005
Posts: 1
|
 Posted: Jul 13th, 2005 09:02 PM Post subject: Passing Listbox data to another access form |
 |
|
I'm stuck and can't get out,
I am trying to have the user select one item in a multi column list box. Then when they double click on that item it should open another form and pass the selection to the new form. This form that opens on the double click has text boxes which display all the fields from the tables for the item selected. The original tables of data come from an excel spreadsheet. This is the code i have for when the user double clicks the item in the listbox;
Private Sub List22_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "router details"
DoCmd.OpenForm stDocName, , , "[Router Name] = ItemData", stLinkCriteria
End Sub
I'm not sure if i am taking the right approach to doing this. Any help would be greatly appreciated. "router details" is the name of the form that opens on the double click and has the text boxes for displaying the selected data. [Router Name] is the name of the text box in the router details form that should display the boundcolumn of the item selected and therefore all other text boxes should base their data on the data in the boundcolumn.
Thanks in advance for any help. |
|
