In the query I have, I have a couple columns that are formatted to standard and percent, but when I set the record source in the list box:
SELECT [qryInvestmentsofAdvisor].[ClientID], [qryInvestmentsofAdvisor].[AssetLiabilityID], [qryInvestmentsofAdvisor].[ClientName], [qryInvestmentsofAdvisor].[NetWorthToday], [qryInvestmentsofAdvisor].[FirmContactID], [qryInvestmentsofAdvisor].[90Change], [qryInvestmentsofAdvisor].[365Change] FROM qryInvestmentsofAdvisor WHERE (((qryInvestmentsofAdvisor.FirmContactID) = [Forms]![frmMainMenu].[Controls]![cboAdvisorInitials])) ORDER BY qryInvestmentsofAdvisor.ClientName;
It doesn't keep the formatting.
The thing is I have another query and list box combo on another tab of this navigation form and it works correctly, and is doing pretty much the same exact thing as I want this one too.
SELECT [qryInvestmentsofAdvisor].[ClientID], [qryInvestmentsofAdvisor].[AssetLiabilityID], [qryInvestmentsofAdvisor].[ClientName], [qryInvestmentsofAdvisor].[NetWorthToday], [qryInvestmentsofAdvisor].[FirmContactID], [qryInvestmentsofAdvisor].[90Change], [qryInvestmentsofAdvisor].[365Change] FROM qryInvestmentsofAdvisor WHERE (((qryInvestmentsofAdvisor.FirmContactID) = [Forms]![frmMainMenu].[Controls]![cboAdvisorInitials])) ORDER BY qryInvestmentsofAdvisor.ClientName;
It doesn't keep the formatting.
The thing is I have another query and list box combo on another tab of this navigation form and it works correctly, and is doing pretty much the same exact thing as I want this one too.