Hello Everyone,
I am new using Access Code and am working on a database derived from a SampleSurvey datatabase found on another site. In short, this database was designed to allow users to evaluate (or rate) certain areas based on their level of cleanliness. Users should be able to select an area, enter certain information (such as the date, time, etc…) and click an Evaluate button that opens another form. This form takes the users through a series of activities that they can rate for that area. There is an append query that will then take those answers and store them in a table.
However, I am experiencing some difficulty with coding to get the form to display the correct Activities for a particular area and append the records to the table. I’d like to be able to filter the number of activities that are rated based on an area’s selection. So, if users select an area – only certain activities for that area will appear in the second part of the form (and not all activities). I’d also like to be able to capture and append all other information (such as the date, time) in the table.
I've hit a snag and can't figure out a work around. Would anybody be able to help me with how to code for something like this or point in the right direction, it would be greatly appreciated. I attached a sample of the database that may help to clarify what I’d like to accomplish. Thanks in advance for any assistance!
Kris
I am new using Access Code and am working on a database derived from a SampleSurvey datatabase found on another site. In short, this database was designed to allow users to evaluate (or rate) certain areas based on their level of cleanliness. Users should be able to select an area, enter certain information (such as the date, time, etc…) and click an Evaluate button that opens another form. This form takes the users through a series of activities that they can rate for that area. There is an append query that will then take those answers and store them in a table.
However, I am experiencing some difficulty with coding to get the form to display the correct Activities for a particular area and append the records to the table. I’d like to be able to filter the number of activities that are rated based on an area’s selection. So, if users select an area – only certain activities for that area will appear in the second part of the form (and not all activities). I’d also like to be able to capture and append all other information (such as the date, time) in the table.
I've hit a snag and can't figure out a work around. Would anybody be able to help me with how to code for something like this or point in the right direction, it would be greatly appreciated. I attached a sample of the database that may help to clarify what I’d like to accomplish. Thanks in advance for any assistance!
Kris
