Display content of one listbox based upon the selected item of ano

[Wendy]

I have two list boxes (unbound), based on the item selected in one list box I
would like to display content in another.
I am unable to use something like this in the underlying query/filter of the
2nd list box Forms![FrmAssignChoices]![lstActivity].column(1).

I know this is simple for you folk out there.

Many thanks

Wendy

 

[Jeff Boyce]

Wendy

Is there a chance that what you have in the second column of the first
listbox is NOT what you want to use for the criteria/filter on the second
listbox?

The .Column() syntax in Access HELP reminds that this is zero-based ...
start counting columns "0", "1", ...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Wendy]

Hi Jeff,
Yup, sure I've got correct column. When trying to use the .column() option,
I get a "Undefined function in expression" error.

I've got around the problem by writing the current ListItem.column() value
into a text box and picking that up in the query. Messy, but gets round the
problem.

Wendy

Wendy

Is there a chance that what you have in the second column of the first
listbox is NOT what you want to use for the criteria/filter on the second
listbox?

The .Column() syntax in Access HELP reminds that this is zero-based ...
start counting columns "0", "1", ...

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have two list boxes (unbound), based on the item selected in one list box
I
would like to display content in another.
I am unable to use something like this in the underlying query/filter of
the
2nd list box Forms![FrmAssignChoices]![lstActivity].column(1).

I know this is simple for you folk out there.

Many thanks

Wendy

 

[Douglas J. Steele]

Another option would be to write a public function that returns the value of
the column:

Function GetListboxValue() As ???

GetListboxValue = Forms![FrmAssignChoices]![lstActivity].column(1)

End Function

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hi Jeff,
Yup, sure I've got correct column. When trying to use the .column()
option,
I get a "Undefined function in expression" error.

I've got around the problem by writing the current ListItem.column() value
into a text box and picking that up in the query. Messy, but gets round
the
problem.

Wendy

Wendy

Is there a chance that what you have in the second column of the first
listbox is NOT what you want to use for the criteria/filter on the second
listbox?

The .Column() syntax in Access HELP reminds that this is zero-based ...
start counting columns "0", "1", ...

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have two list boxes (unbound), based on the item selected in one list
box
I
would like to display content in another.
I am unable to use something like this in the underlying query/filter
of
the
2nd list box Forms![FrmAssignChoices]![lstActivity].column(1).

I know this is simple for you folk out there.

Many thanks

Wendy