N
new2access via AccessMonster.com
i have training schedule query consisting:
qryTrainingSchedule:
- EmpID (number)
- LastName (text)
- FirstName (text)
- TrainingDate (Short Date)
im planning of having a combo box on my main form and display the records in
the subform based on my selection.
im having trouble in thinking the best way to display the records i want
which is as follows:
a combo box which displays:
- current month's training schedule (which is the default data to appear when
the main form is opened) based on my query
- display next month's training schedule
- or let the user input the training date range (From - To) using unbound
text box and use a command button to display trigger the event???
can you please help me out on this one..
Thanks.
qryTrainingSchedule:
- EmpID (number)
- LastName (text)
- FirstName (text)
- TrainingDate (Short Date)
im planning of having a combo box on my main form and display the records in
the subform based on my selection.
im having trouble in thinking the best way to display the records i want
which is as follows:
a combo box which displays:
- current month's training schedule (which is the default data to appear when
the main form is opened) based on my query
- display next month's training schedule
- or let the user input the training date range (From - To) using unbound
text box and use a command button to display trigger the event???
can you please help me out on this one..
Thanks.