OpenFormBelow new record - Account Balances in Microsoft Access, Part 6


	Back to Account Balances 6 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

OpenFormBelow new record

Tannim Hallman

2 years ago

I'm using the OpenFormRight and OpenFormBelow in my main DB. They work like charms, and are very handy. I've got my AppointmestListF set to open to the right of MainMenuF and ContactF opens below that and matches width. Both happen in OnLoad events. I'd like ContactF to open to a new record. I can make it load with a client's data by opening ClientF as hidden in the MainMenuF OnLoad, and I know how to do it with DoCmd.OpenForm but it doesn't seem to be an option in OpenFormBelow. Does it somehow fit in the where condition?

	Alex Hedley @Reply 2 years ago
Open New Record

	Tannim Hallman OP @Reply 2 years ago
I tried that, and it's not opening to a new record. Private Sub Form_Load() OpenFormBelow "ContactF", "AppointmentListF", True DoCmd.GoToRecord acDataForm, "AppointmentListF", acNewRec End Sub

	Richard Rost @Reply 2 years ago
What's it doing? Let's see a screenshot.

	Tannim Hallman OP @Reply 2 years ago

	Tannim Hallman OP @Reply 2 years ago
As you can see, it's pulling all contacts for all clients, which it's doing because I've not got it filtered with dlookup, which is fine because I just want her to enter new contacts here and look up all contacts through the client form or clicking the contact form button in the main menu.

	Kevin Robertson @Reply 2 years ago
One of the optional parameters is WhereCond. Set the ID to 0 and you will be on a new record. `"ContactID=0"`

Kevin Robertson @Reply

2 years ago

Another way would be to add an additional optional parameter (I added it after WhereCond).
    Optional DataMode As AcOpenDataMode = acFormPropertySettings

Then add DataMode to the Docmd.OpenForm in the Public Sub in the Module.
    DoCmd.OpenForm FormToOpen, , , WhereCond, DataMode

Then use acAdd in the code that calls the sub, for example:
    OpenFormRight "CustomerF", "MainMenuF", , , acAdd

	Tannim Hallman OP @Reply 2 years ago
Brilliant! Thank you!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Account Balances 6.

Next Unseen

New Feature: Comment Live View