Hi! I'm very new to access and was wondering if I could get some help with quite a simple question. I'm not really sure how to explain this, but I have a data entry form for a query that generates a list of customer orders. I've attached the file, hopefully you can see the issue more clearly when viewing the file. When attempting to enter data into this form, I am unable to enter the QTY value as a text box for some reason. I tried using a combo box, but this is not ideal for me and I would like to have a text box so that any numeric value would be possible.
Furthermore, I am not able to make all my data from my form successfully enter into the query. I am not sure of the cause of this, and I can hope somebody can help me out.
The error can be seen in the form New Order / Order List (whatever it is currently named.)
P.S This is an assignment, not an actual database. As you can probably tell I am very new to access.