Customer Agreement Form

[Gwill1983]

Hi all,

Still finding my feet with Access and have hit a bit of a block so just after a little guidance to see if what I am trying to do is possible, or if I am barking up the wrong tree!

I have created a database for some hire equipment and now want to create a form within access which will become the agreement form to send to a customer. Ideally this form would have stored text (for terms and conditions etc) which will always appear, but also variable fields where I will be able to select which items to add (maybe from a drop down box pulling from my asset list?)

I am not looking for design assistance as such, just trying to see if this is possible or if I am approaching it the wrong way.
I have designed a few different forms for my database, but this is the first which needs to become 'customer friendly' so any pointers would be appreciated!

 

[Micron]

IMO you want to create a form that will allow you to make whatever edits you require, then you open a report based on that. Forms can be printed but they are sorely lacking in the result AFAIC. If the form and report contain the same fields the easiest method might be to open the report with a Where condition. Can also use a query as a filter. See

Apply a filter when opening a form or report

Office VBA reference topic

docs.microsoft.com

 

[Gwill1983]

IMO you want to create a form that will allow you to make whatever edits you require, then you open a report based on that. Forms can be printed but they are sorely lacking in the result AFAIC. If the form and report contain the same fields the easiest method might be to open the report with a Where condition. Can also use a query as a filter. See

Apply a filter when opening a form or report

Office VBA reference topic

docs.microsoft.com

Thanks alot. That sounds like a much better idea!
I will give that document a read and get it sorted.

Thanks for your reply

 

[Micron]

You're welcome. Post back if you get stuck with your code.