T
tdmailbox
I have a form that has a drop down of criteria. From time to time
certain choies from the dropdown are made inactive and shouldnt be
chooseable.
The problem is that once I make a choice inactive when I revisit any
record in the form that picked that choice I see nothing. The reason
for this makes total sense to me I am just not sure the work around.
SELECT criteria, dbo_tbl_pro_monitor_report.idnum
FROM dbo_tbl_pro_monitor_report
WHERE (((dbo_tbl_pro_monitor_report.actve)=True));
This is my query, not much to it. I tried turning off limit to list
however my bound value is the idnum and it doesnt seem to allow me to
turn off limit to list unless that is the first column in the drop down
and therefore the value that displays after the drop down is selected.
I am looking to display the "criteria" in the box not the idnum.
Is there any way for me to display the criteria text in the box if a
user selected that for a record and not make this certain choice
selectable in new records if I have set the active vale for that choice
to false?
certain choies from the dropdown are made inactive and shouldnt be
chooseable.
The problem is that once I make a choice inactive when I revisit any
record in the form that picked that choice I see nothing. The reason
for this makes total sense to me I am just not sure the work around.
SELECT criteria, dbo_tbl_pro_monitor_report.idnum
FROM dbo_tbl_pro_monitor_report
WHERE (((dbo_tbl_pro_monitor_report.actve)=True));
This is my query, not much to it. I tried turning off limit to list
however my bound value is the idnum and it doesnt seem to allow me to
turn off limit to list unless that is the first column in the drop down
and therefore the value that displays after the drop down is selected.
I am looking to display the "criteria" in the box not the idnum.
Is there any way for me to display the criteria text in the box if a
user selected that for a record and not make this certain choice
selectable in new records if I have set the active vale for that choice
to false?