Unsure why you need a new blank form? Don't you mean a new record?
1. Anyway, either create a query or use table as record source for form.
2. Make View Review a combo with a lookup for what you want
3. Do you mean to exit the database , if so just use the OnClick Event and put DoCmd.Quit
Or do you mean to close the form?
If so, DoCmd.Close
4. Update Review
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Your Form Name Here"
DoCmd.OpenForm stDocName, , , stLinkCriteria
I don't know what form you are referring to to edit, but you add code to open that form and then close the form you are on.
NO. Just add that code to the OnLoad Event of your form.
In design mode double click the square at the top left part of the form.
This will open up the forms properties,scroll down to the OnLoad Event and double click in the field, this will then show a Event Procedure,click on the square to the far right with the 3 dots on it.
Do a copy and paste of the code,close and save.