Forms opening on new record entry

[daddylongtoe]

Hi

Currently I have a form which opens to allow the user to enter a new purchase order. The problem I have is that when you open the form it always displays the first record from the table.



Want I want to know is how can I set the form to open ready for a new entry by default?

Thanks

Steve

[maximus]

go to Form Properties - Data - Data Entry - Select Yes

[maximus]

if you are opening the form using a command button you can also add acFormAdd
DoCmd.OpenForm stDocName, , , stLinkCriteria,acFormAdd

[daddylongtoe]

Thanks for the response, that does work. I was hoping to allow the user to still go back through previous record entries using the same form if possible. Making the change in the form properties to Data Entry: Yes doesn't let me go back through previous record entries.

If this isn't possible I may just have to add a seperate form for viewing previous entries and use the current one for adding new ones. How do I change the viewing order so it displays the most recent entry first?

Thanks again

[maximus]

Hi

Currently I have a form which opens to allow the user to enter a new purchase order. The problem I have is that when you open the form it always displays the first record from the table.

Want I want to know is how can I set the form to open ready for a new entry by default?

Thanks

Steve

Well it seems that your problem has changed:

to display all the info back again on the form DataEntry property has to be set to no.

E.g.

put this piece of code in the onclick event of a command button on the form.
Me.DataEntry = False

I have a product form which opens in the data entry mode. what I have done is that I have made the record source:

SELECT Products.Products_Id, Products.Product_Name FROM Products ORDER BY Products.Product_Name;


This ensures that the data is displayed by the order of product names but as the DataEntry property is set to yes a blank form opens all the time. But now when I click the command button wit the code all data is displayed. Hope this will help you. If it does mark the thread solved.