CREATING MULTIPLE SELECTION LIST W/ABILITY TO ADD TO LIST

[bflemi3]

I am creating a database for all company contracts. Each contract is by division. I have made a form to enter each contract.

A contract can have numerous requirements. On the same form I need to create a list that you can select numerous requirements from; or if the requirement is not in the list, have the ability to add the requirement to the list.

As you can probably tell, I'm new to Access. I have no visual basic knowledge. Also, can anyone suggest a good book to learn VB.

Thanks for all your help in advance. More questions to follow...I'm sure.

-B

 

[Andrew Fergus]

Hi
Can you elaborate on the 'requirements'? Is there a core set of requirements that are common to most contracts? And if there are any additional requirements, what sort of things would you expect? Lastly, what have you done so far?
Andrew

 

[SydneyGeek]

Go to Helen Feddema's website and check the examples in the Access Archon section. At least one of those will do the trick for you.
Also, if you want a good intermediate / advanced book on Access, with plenty of code samples, try her book -- Microsoft Access Version 2002 Inside Out (Microsoft Press).