VBA Code to Open Form

[kevins]

I have created a button to do a saved import, and would like Access to then immediately open the form that I imported the information to. I can't figure out the right code though. Since it is the newest entry, therefore the highest ID number, I figured I could use a code that retrieve the max ID number but I can't quite figure it out. Any help would be greatly appreciated!

Private Sub Command125_Click()
DoCmd.RunSavedImportExport "New Candidate Import"


DoCmd.OpenForm ("Candidate Details",,,[max(ID)],,,)
End Sub

[June7]

Do not use parentheses. Need full criteria expression.

DoCmd.OpenForm "Candidate Details", , , "[fieldname]=" & DMax("fieldname","tablename")

"Candidate Details" is NOT used as subform?

[kevins]

Thanks, June. I tried it and I'm still getting an error. Is there another piece of criteria I need to add? I've included a screenshot.

[June7]

Candidates is table name? ID is autonumber field in Candidates table?

You are missing the closing paren of the DMax().

Remove that last comma because nothing follows.

[kevins]

Yes, Candidates is the table name, and with each new candidate, a new ID is given which is just a higher number than the last. I've attached an image of the error I received. Thanks!

[June7]

Look at my example in post2 again. There are no parenthesis enclosing the DoCmd arguments. Remove them from your code.

[kevins]

Always one little detail

Thanks June, it's working perfectly now!