I dont know if this can be done in MS or not. I have a form and want to choose a species and then change some of the information on the from based on what species is choosen. For exmaple if deer are choosen it woudl display only the infoamtion realted to deer, if fish were choosen it would only disoplay the information relted to fish. So all info woudl need to be saved in the form but based on a key word it woudl only disoplay the associated informaiton. the goal is to have one form vs needed to have multiple forms for each species.

Yes, it can be done. There are a number of threads in this forum showing how.

For example,
See the "Cascading Listboxes" section of the following page of Greg Maxey's website:
Populate Userform Listbox or Combobox
(Doug Robbins)


You can also use IF fields conditioned on bookmarked answers.