I have a form for data entry, and then I am basically copying this form and
re-tooling it for editing and reviewing. I would like for the user to be
able to select pond name and then date sampled (or vice versa). The pond
name is to be selected from a combo box. As for the date, I am not sure
what is the best way to approach this. Put the date in a combo box, too?
There is another database I currently use (made by someone else) that has a
calendar pop up and you can select the date and it automatically enters it
into the field. I like this... But I do not know how to create this calendar
pop up where each day is selectable... and then how do I get it to all work
and automatically populate the rest of the fields in the form and its
If both pond and date fields are combo boxes, how do I get the first combo
box to limit the choices in the second combo box? If just the pond name is
in a combo box, I'd still like to know how to limit choices in a second combo
box because I might need that later! :-)
Is there a MS Access tutorial on this somewhere?
Your guidance is greatly appreciated!