Auto enter a delivery each month for a year on same day each week

[Candace]

I We deliver loads and some people call and want us to do 1 every week for the year and some may want 2 per week for the year. Others just call and order when they need. It gets pretty busy so this is a simple order board to track orders, deliveries and cancelled deliveries. I have the board and tables and forms and things already done and it works great. The board opens to a multi record form that you can only view. All the buttons to add, change and cancel orders are on that form. I would like to put another button to set up a form that lets you enter ((along with the regular info) or even add to the new order form)) how many loads, in what period of time and for how long on that schedule. And add the records when you click save It would be a cool addition.

[Micron]

All I can get from your post is that you want to put a button on your existing form which will open another form that you haven't created yet. Is that right?

[Candace]

Yes...what all would I need to do to make everything happen the way I explained it? What would be the best way to generate duplicate records per scheduled date? Can you send me in the right direction..with what I need to do?

[Micron]

Sorry, your post is too confusing. You say that the form is view only, yet it has these buttons to add, edit and delete and yet everything works great. Why don't you just use the form you have to add, edit or delete records instead of creating another one? To answer part of your question, a button would need a click event that uses the DoCmd.OpenForm method. Since it has parameters that may be significant to you, I'm posting the link as opposed to a stripped down version of its use: https://msdn.microsoft.com/en-us/lib.../ff820845.aspx

Again, it is usually preferable to minimize the creation of db objects such as forms/reports. Re-using or changing properties is the better way to go when possible. In your case, perhaps that is changing the form from view only to being able to modify records, based on some sort of condition such as user permissions. You'll have to provide much more clear and concise information about what you have and what you need or want to do (and why) and how it fits into a process. BTW, duplicating records is usually a bad idea.