Help with a listbox

[Vallan]

Hello.

Probably has this issue been up before bnut cant find it.

We have upgraded our system to access 2010 and there im stuck with a problem.


I have a form with a listbox. i want to make a choice in the listbox and click open.
Then all the information about the person comes up in a new form.

I use an inbedded makro and use openform.
My problem is the "where" choice.

I try with Where = [Person_ID] = [Person_listbox]


I hope you understand my issue and can help me with this...easy problem.


Sorry for my bad english


Mat

 

[John Big Booty]

Check out the OpenForm method.

Your Where clause should look something like

"Person_ID = Me.Person_listbox"

this assumes that the bound column of the list box holds the Person_ID, otherwise your where clause will look something like;

"Person_ID = Me.Person_listbox.Column([B][COLOR="Red"]x[/COLOR][/B])"

Where x represents the column that holds Person_ID, remember that the columns in a list box (and combo for that matter) are numbered from zero up, the zero column is the bound column and is often hidden.

 

[Vallan]

Cant it right.

Have tried all kind of thing but with no luck.


Any one who can give me a hint i apprecciate it.