Hi I have made lots of Access databases over the years but it seems I have fogotton lots of basic principles since I have not used it for ages.
One thing I want to do is:
For instance when you send an email using Yahoo or similar webmail if you are adding an attachment there are 5 spaces to add 5 file attachments. If you are adding more than 5 you click on add more files and another box appears ready for you to add another attachment.
I want this to happen in Access only instead of adding file attachments I want it to add a como box each time that is controled by data in one of my tables.
I.e. 1 blank combo box that I can drop down and select a product. then click add new and another blank combo box would appear underneath it and so on. Also eventually the space would run out so the actual form size would need to auto grow to accomodate the extra fields.
Any ideas? Please be nice I am not a newbie but you may as well treat me as one until I remember how things roll.