O
OregonIzer
I cannot figure out what I am doing wrong (after the first questionable move
of sitting down at the computer) (ACCESS 2000)
I am putting together a form to choose a report.
I have a table "Reports" with the fields:
ReptId - Autonumber
ReportName
ReportDescription
ReportType
I have a combo box that allows me to select a report type from the field
ReportType
e.g. Lists,Analysis
I then want to populate my list box with reportDescriptions that match that
report type:
SELECT DISTINCTROW Reports.ReportDescription
FROM Reports
WHERE (((Reports.ReportType)=[Forms]![FrmReports]![cboRepType]))
ORDER BY Reports.ReportDescription;
This often works once after I put in the query - but every time I try to
save it or close the form and reopen it changes the field in my query from
ReportDescription to ReportType and my list box repeatedly shows the value in
the combo box.
HELP! HELP!
of sitting down at the computer) (ACCESS 2000)
I am putting together a form to choose a report.
I have a table "Reports" with the fields:
ReptId - Autonumber
ReportName
ReportDescription
ReportType
I have a combo box that allows me to select a report type from the field
ReportType
e.g. Lists,Analysis
I then want to populate my list box with reportDescriptions that match that
report type:
SELECT DISTINCTROW Reports.ReportDescription
FROM Reports
WHERE (((Reports.ReportType)=[Forms]![FrmReports]![cboRepType]))
ORDER BY Reports.ReportDescription;
This often works once after I put in the query - but every time I try to
save it or close the form and reopen it changes the field in my query from
ReportDescription to ReportType and my list box repeatedly shows the value in
the combo box.
HELP! HELP!