B
BIGRED56
Hi I would like to ask a question on list boxes..
I have a list box where I send 5 feilds from my table(NamePlate). The
records appear in there and are filtered by 4 combo boxes and 4 command
buttons.
I would like to have a start and end date input box to give me another
filter on the list
-my existing combo boxes are not in a query so they are linked to the list
by table(NamePlate)
- when i tried to link 2 text boxes one "end" and the other "start date" to
the list together by query it would only query the initial results to the
list, but once i clicked on a combo box the list then became rowsource to the
table.
-I then set up a command button to query the list on click.THIS WORKed, but
it gave me a dialog box that was not editted to my specifications rather it
said "forms!list2!txtBegin and the other was forms!list2!txtend"
-IS there a way to edit this and say Enter your start date and another that
says enter an End date"
Is this best method--PLEASE HELP
I have a list box where I send 5 feilds from my table(NamePlate). The
records appear in there and are filtered by 4 combo boxes and 4 command
buttons.
I would like to have a start and end date input box to give me another
filter on the list
-my existing combo boxes are not in a query so they are linked to the list
by table(NamePlate)
- when i tried to link 2 text boxes one "end" and the other "start date" to
the list together by query it would only query the initial results to the
list, but once i clicked on a combo box the list then became rowsource to the
table.
-I then set up a command button to query the list on click.THIS WORKed, but
it gave me a dialog box that was not editted to my specifications rather it
said "forms!list2!txtBegin and the other was forms!list2!txtend"
-IS there a way to edit this and say Enter your start date and another that
says enter an End date"
Is this best method--PLEASE HELP