GoTo new record on main form from a cmd button on subform

[Kipandrews06]

I'm sure I'm probably an idiot and this is an easy fix, but I'm having trouble figuring out how to get my DoCmd.GoToRecord function to go to a new record.

So I have a main form with two subforms.



On subform 1, it is just a product list
On subform 2, it is an item cart

I had a hard time coding my item cart to update all the products and the amounts when submitted so I wasn't able to get the cmd button "Submit Order" to be on the main form, it had to be with the record source on the item cart or else I probably wouldn't be having this issue. So I have it where the submit order button is on the item cart (subform 2). The problem I am having is when I try to do the DoCmd.GoToRecord,,acNewRec it keeps saying I have a type mismatch error. I've tried referencing my main form which is called frmOrderDetails. I've tried the setfocus on it and it is still not working. Does anyone have any ideas on how I get the main form to go to a new record from a cmd button on subform 2?

My main form is called frmOrderDetails
My subform2 is called frmItemCartOrdersSubform

[Micron]

Type mismatch means you're trying to put a value in a field or control that wants a different type. That can be text where only numbers/dates are allowed, or Null (no value) where it is not allowed to be Null. Text fields will accept numbers but will convert them to text if possible.

[Kipandrews06]

Yeah I am stumped. Because I've tried about 15-20 different variations. I just tried this:

 DoCmd.GoToRecord acDataForm, "frmOrderDetails", acNewRec

and this gave me an error:2046 cmd or action isn't available right now.

[Micron]

So now a different error? Make sure you can go to a new record interactively (e.g. via ribbon or built in form record navigation controls). If not, you can't do it by code. Your form records could be read only, thus you can't go to new. Could also happen in code if you're already at a new record. Could also be that the form you want to do this on has lost the focus. Either a db copy or more code would help. One line of code isn't much to go on. Probably need the whole sub/function.

[Kipandrews06]

I was able to fix it by doing a SetFocus on the main form. I had tried it before I posted but I guess I did with with an incorrect syntax or something. Really not sure.

[Welshgasman]

To me, that would be very confusing (easliy done I know ), but put objects for the subform on the subfom and object for the main form on the main form?

[Kipandrews06]

@Welshgasman LOL yeah I guess it is a little confusing. I've never done an order form with an item cart before so I've been learning on the fly. Basically I have a main form with two subforms. One of the subforms is a product list where they simply scroll through the products they need and can click on an add button which adds the product into the other subform which is an item cart. All the forms are linked together and are in sync but have different record sources. The main form is where they enter in all the address information, but when they are done, they click on a submit order button in the item cart subform which loops through all the products in the item cart and deducts the qty they order from inventory and then make the main form and both subforms go to a new record which is where I was having an issue in this post. Once I did the SetFocus to the main form, it fixed the problem and works perfectly now! This is the code that fixed it:

     Forms!frmOrderDetails.SetFocus
                DoCmd.GoToRecord , "frmOrderDetails", acNewRec

I was using a bracket for the frmOrderDetails instead of "" and I took out the acDataForm