To preface my question sorry if what I'm asking is really basic the only experience I have with access is how to link tables together.
And as far as VBA goes my only other experience of using it was in excel using it for closing and opening forms.
One last thing my teacher in school is very bad at teaching us :banghead: about MS access which really doesn't help with my lack of experience.
So my system allows users to place orders and on the form where they enter their customer account number and which items they want as well as quantities I want there to be a dropdown box from which they can choose which product they want. However all I've been able to achieve so far is a form with a subform containing what looks like another table in it (see screenshot in zip file).
I am also wondering is there a way to not have a table but instead textboxes where the user can choose the item and enter a quantity and when they have done that another set of textboxes appears for them to enter a product, so there isn't lots of empty textboxes on the screen at once.
If what I'm asking seems too complicated for a beginner them please let me know as I don't want to get in too deep, I have to explain how my entire system works in my write up so it would definitely help if I understood how it all works.
P.S. any basic explanation of how some of the VBA works would be a great help, links to other websites that explain it are greatly appreciated.
All of the VBA currently in my system was done by a friend who helped me get started and also made me realise I am way in over my head with this.
And as far as VBA goes my only other experience of using it was in excel using it for closing and opening forms.
One last thing my teacher in school is very bad at teaching us :banghead: about MS access which really doesn't help with my lack of experience.
So my system allows users to place orders and on the form where they enter their customer account number and which items they want as well as quantities I want there to be a dropdown box from which they can choose which product they want. However all I've been able to achieve so far is a form with a subform containing what looks like another table in it (see screenshot in zip file).
I am also wondering is there a way to not have a table but instead textboxes where the user can choose the item and enter a quantity and when they have done that another set of textboxes appears for them to enter a product, so there isn't lots of empty textboxes on the screen at once.
If what I'm asking seems too complicated for a beginner them please let me know as I don't want to get in too deep, I have to explain how my entire system works in my write up so it would definitely help if I understood how it all works.
P.S. any basic explanation of how some of the VBA works would be a great help, links to other websites that explain it are greatly appreciated.
All of the VBA currently in my system was done by a friend who helped me get started and also made me realise I am way in over my head with this.
