If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using Combo Box selections to automatically populate fields
I have a form for data entry, and then I'm 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'm not sure what's the best way to approach this. Put the date in a combo box, too? There's 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 don't 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 associated subforms??? 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! Jill |
#2
|
|||
|
|||
Using Combo Box selections to automatically populate fields
Here's a link about 2 combo boxes - called cascading combo boxes.
http://www.rogersaccesslibrary.com/f...ts.asp?TID=389 Here's a link for a pop up calendar form http://www.allenbrowne.com//ser-51.html The above will get you started. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Jill" wrote in message ... I have a form for data entry, and then I'm 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'm not sure what's the best way to approach this. Put the date in a combo box, too? There's 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 don't 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 associated subforms??? 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! Jill |
#3
|
|||
|
|||
Using Combo Box selections to automatically populate fields
Great! Thank you, I'll take a look!
It's always good to get the terminology. It's complicated when one doesn't know the terminology, it can get quite wordy in Google searches! "how to make a selection of a combo box limit the next combo box" "combo box selections" "how to make fields fill in" You get the gist! :-) Jill "Jeanette Cunningham" wrote: Here's a link about 2 combo boxes - called cascading combo boxes. http://www.rogersaccesslibrary.com/f...ts.asp?TID=389 Here's a link for a pop up calendar form http://www.allenbrowne.com//ser-51.html The above will get you started. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Jill" wrote in message ... I have a form for data entry, and then I'm 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'm not sure what's the best way to approach this. Put the date in a combo box, too? There's 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 don't 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 associated subforms??? 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! Jill . |
Thread Tools | |
Display Modes | |
|
|