T
Tony Cannizzo
I have a query that is displayed in a multi-column list box on a form.
AccountID, IndividualID, Account Name, Individual Name, Phone Number
AccountID and IndividualID are suppresed with a 0";0" column width
A macro is initiated that opens two forms via DblClick on a particular row
The two forms are Account Profile and Individual Profile
The filter on the Account Profile is fine -
[accounts]![AccountID]=[Forms]![_Dashboard]![today on main]
But the filter used to open the Individual Profile is misbehaving"
With the expression builder, I enter
[individuals]![IndividualID]=[Forms]![_Dashboard]![today on main].Column(1)
but it converts it to
[individuals]![IndividualID]=[Forms]![_Dashboard]![today on
main].[Column](1)
which doesn't work.
Any help would be appreciated.
Thanks.
Tony C
AccountID, IndividualID, Account Name, Individual Name, Phone Number
AccountID and IndividualID are suppresed with a 0";0" column width
A macro is initiated that opens two forms via DblClick on a particular row
The two forms are Account Profile and Individual Profile
The filter on the Account Profile is fine -
[accounts]![AccountID]=[Forms]![_Dashboard]![today on main]
But the filter used to open the Individual Profile is misbehaving"
With the expression builder, I enter
[individuals]![IndividualID]=[Forms]![_Dashboard]![today on main].Column(1)
but it converts it to
[individuals]![IndividualID]=[Forms]![_Dashboard]![today on
main].[Column](1)
which doesn't work.
Any help would be appreciated.
Thanks.
Tony C