Take a screenshot of the actual code that you have put in, and post it here

Lee You are trying to go to an existing customer.

If what you want to do is add a new customer:
    DoCmd.OpenForm "CustomerF", , , , acFormAdd

Thank you Kevin. I had to remove one comma but it works now. Thank you to all.

Lee


Docmd.OpenForm"CustomerF",,,"CustomerID="&CustomerID

This line does not have spaces in the correct places.  You need space between:
- Docmd.OpenForm-space-"CustomerF"
-"CustomerID="-space-&-space-CustomerID

"CustomerID=" & CustomerID is the WHERE condition, which is telling the form to OPEN the form, then go to the record WHERE CustomerID = CustomerID from the Record you are currently on.

Kevin's suggestion will take you to a new Record.

If you have a Form properties set to NOT allow adding or changing records, you will need to set these in VBA:
- Add Records set to True (only if you have this set to false)
- Fields will need to be enabled so the user can make changes (only if these are disabled)
- Allow Edits set to True (only if you have this set to false)
- Allow Deletions set to True (if you want the user to be able to delete records)

-Raymond

Raymond I should have typed it like I had it typed in event builder. I had all the spaces and I wasn't thinking about that when I posted. Kevin's way worked with just removing one comma for some reason. But it worked I now have something to learn and work with.

Lee

Understood.  This is why we always ask to see your actual code.  If you post code with mistakes or errors, you're going to get comments on it.  Code is very specific, one letter off, or one missed space, or one mispelling can cause your code to not work.

-Raymond

My bad. You are correct. I just wasn’t thinking apparently.