Help creating forms

[VickieC]

I am creating an access database to store customer details as well as quote information. I have created a form to input quote details that our office can complete when a customer calls to complete a quote. I need to create a form that opens as a new form every time we click on the form to input a new quotation. How do I do this? At the moment when I click on the form, the form opens but the details of the last quotation are stored on the open form.

I have no training in access at all and am self taught so far so by no means an expert

I also want to create a form that allows you to search for particular quote numbers, so if someone calls and asks about a particular quote number we click on a page that says 'search quotes', input the quote number and the form opens with all the details of that quote.

I am sure it is simple enough but when you don't know what you are doing it's quite confusing

If anyone can help that would be greatly appreciated.

Kind Regards

Vickie

 

[Sunny Boy 1318]

Use the below code: You will be able to call the Quote number details by using VBA but first of all, you will need to create a report comprising of all the details you want to see for the quote number.

DoCmd.OpenReport "Rpt_Name", acViewReport, WhereCondition:="[QuoteNumber] = " & Me.QuoteNumber & ""

 

[magster06]

I need to create a form that opens as a new form every time we click on the form to input a new quotation. How do I do this? At the moment when I click on the form, the form opens but the details of the last quotation are stored on the open form.

Go into design view for your form, then click on the data tab of the properties sheet. Under the data tab, go to data entry and click the "yes" to allow data entry. When you open the form, then it will start as a blank form.