Collect data via email

[danassef]

I'm attempting to use the collect data option within Access 2007. Presently we use paper forms that are then re-enteed into an Access database. Im tryin to automate this by having our employee fill out a form of their activities. I have already set up a query of the information I need on the form and have been able to sent this form out through Outlook. The problem I'm having is that I need to control what is typed in the boxes on the form. Like with the activity box on the form, I get abbreviations of what I need, some even put the wrong informaiton in the box. I would like to be be able to use a list box on the form to force the person filling out the form to pick one of the official activities we track in our master database. In my query for this form I have a dropdown box that control this and forces you to select the appropriate choice. This is what I would like to do on the form by placing dropdown boxes or list boxes on the form. Is there anyway to do this on the form that is email outed from Acces through OUtlook using the collect data option in Access?

 

[Guus2005]

Hi danassef,

I know you can send forms using outlook. You can give the form controls for people to fill in. Can't you use a combobox? Instead of attaching it to a recordset you might be able to use the values property and fill the combobox that way.

To be honest, i've never used it and i am using Lotus Notes so i can't even try.

HTH