Elaine has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
MORE buttons on a form
I've created an order form and I need to add a 'more' button onto it which allows me to add more items to the list of products being bought. It needs to be unique to each order so cannot be a subform.
Please help!
Thanks.
RE: MORE buttons on a form
HI
Thanks for phoning in, it made what you were trying to achieve must clearer. What you need to do is to have:
Order table
Item table
OrderItem table
Item table: contains a list of all items that can be ordered along with ID etc
Order table: holds all of the details about the order, however not what has been ordered.
OrderItem table: holds all information about the items ordered for a particular order.
Then in you order form - you have the order details at the top and then you are able to have a sub from for the orderItem as it is now a separate table. Thus orderItems are linked to an Order. So you sub form can be just a simple table format, which can have 1 or many rows.
Hope this helps
David
RE: MORE buttons on a form
Hi David,
That works great - One more question though.
In my order form if I choose to add a new record the order items are still appearing. How can I make them exclusive to the order?
Elaine
RE: MORE buttons on a form
Hi Elaine
Just make sure that you have the form set up properly - ie that you have the correct query for the sub form as you need to link the order item ID to the actual order item. If it is not linked then it will generally show all of the order items for regardless or which order it is.
Hope this helps
David
RE: MORE buttons on a form
Hi David,
Please can you tell me how I can change the appearance of the sub-data sheet in the order form?
Thanks,
Elaine
PLEASE HELP
Forgive me, I'm confused. I don't understand what I am asking my query to do.
Please help me.
Elaine
RE: PLEASE HELP
Elaine,
You just need to make sure that everything has a UNIQUE ID, the order item table must have a unique ID, the order item must have a unique ID. The order item table should contain a field called order which contain the unique order ID. If you make sure you are using unique ID's you should have no problems.
Hope this helps
David
