I am trying to open a form using the where clause to max of a table field. I cannot get the syntax correct. DoCmd.OpenForm "frmInput", , , Max(tblClients.ClientID) AS MaxOfClientID FROM tblClients