DoCmd OpenForm to new record

[jzeig1]

Hay all. I will try to make this as simple as possible, but I know you need as much info as well: ;-)

I have a main form that has a comboBox(cmdMemberName) the has member first and last name orderBy last name, which is the first field in the dropdown.
I have two buttons on the presently (will add 'delete' button later): one is cmdEditMember the other is cmdNewMember.


I was working with at tutorial that uses the following code:

DoCmd.RunCommand acCmdRecordsGoToNew Me.mbr_LastName = " "
Call cmdEditMember_Click

That would work fine if I was in datasheet view or the my current focus was on a record within that data sheet, but I'm using a comboBox to populate a subform. I'm not trying to change any of the values in the subform, just the member list within the cmbBox.
Using the code above, the idea here is that the current form would create a new record when cmdNewMember is clicked; fill in [LastName] with a blank value; then cmdEditMember would extract the openArg value to goto to the new record.
This won't work for me cause I'm using a comboBox, and it doesn't allow edit in that manner - not to mention that the 'notOnList' event would trigger; additionally, if there was a way to do it using the comboBox properties, it would probably be lengthy. That-being-said:

DoCmd.Close acForm, "frmMbrDonation"
DoCmd.OpenForm (frmMemberInfo,acNormal,,,acFormAdd,acWindowNormal ,,)

I was trying to open it using the cmdNewMember button to open the form and set it to a new record. I've tried the above code but I get an error (Compile error: Expected expression)

Thanks

[jzeig1]

Nevermind. I sat down and walked thru it.

Here's what I came up with.

DoCmd.Close acForm, "frmCurrent"
DoCmd.OpenForm "frmMemberInfo"
DoCmd.RunCommand acCmdRecordsGoToNew

That seems to work.

[pbaldy]

Welcome to the site and thanks for following up with your solution. Your OpenForm was on the right track with acFormAdd. The form name needed to be in quotes and I don't think you needed the parentheses. The trailing commas may also have been a problem.

[jzeig1]

Welcome to the site and thanks for following up with your solution. Your OpenForm was on the right track with acFormAdd. The form name needed to be in quotes and I don't think you needed the parentheses. The trailing commas may also have been a problem.

Thank you. If it ain't broke, don't fix; therefore, I'll leave it the way it is for now. I'll try to use the 'OpenForm' syntax with all those parameters later - it would be good to understand the function all the parts.

"I'll be back!"

[pbaldy]

I have the same philosophy. That said, your method could get slow if the underlying table gets large, since all records would be returned. Just a heads up.