Opening a select record from a list box in a new form?

[simonc88]

Hi guys hope you can help with this one,

I have a list box being fed by a table, the list box has 3 columns with the first being an ID number and displays the records that are saved in the table. I want to allow the user to double click on one of the records shown the list box which in turn would open up a form which would be populated with record that you clicked on.
I have tried many different ways to link the ID number with the record saved in the table but have had no such luck, any help or guidance would be brilliant!

Thanks!

[NeoPa]

What are the relevant parameters of the ListBox control set to?

[simonc88]

Sorry i have only just got back into Access programming so i am still getting back up to speed with it, i was hoping we would be able to start from scratch?

[NeoPa]

It seems we're going to need to concentrate to communicate here.

What do you mean start from scratch?

Is my question complicated for you?

[simonc88]

It seems we're going to need to concentrate to communicate here.

What do you mean start from scratch?

Is my question complicated for you?

Yes sorry i dont understand what you mean

[GazMathias]

The simple way to achieve what you want is to have the query behind the form you want opened look at the listbox.

Type: Forms![YourForm]![YourList] in "Criteria" in the query design mode.

Then have the double click event of the list open the new form.

This does restrict you to only opening the form in this way, so a better way would be to pass the ID number in the OpenForm command:

DoCmd.OpenForm stDocName, , , "[IDFieldName]=" & Me![YourList]

Also, make sure the Bound Column in the list is set to the column number containing the ID field.

Gaz

[NeoPa]

Yes sorry i dont understand what you mean

OK. In the absense of direct response to my questions I will assume that you are happy dealing with Gaz. I suspect we would struggle to understand each other anyway, so no loss.

Of course, if you need me holler.

[simonc88]

Gaz,


I understand what you said and added that function in, instead i am using a button rather a double click event. When i tried running the formula i had a message box asking me for the Parameter value, rather than going straight to the form. Do you know why this is?

[GazMathias]

Gaz,


I understand what you said and added that function in, instead i am using a button rather a double click event. When i tried running the formula i had a message box asking me for the Parameter value, rather than going straight to the form. Do you know why this is?

Sure, make sure that all forms, controls and fields are referenced correctly throughout.