Multiple Record Query For Statement

[mcadle]

Yeah that is what I was referring to, but I have a syntax issue.

DoCmd.Openform "fleet2",,,"[vehicle number]=forms!form1![vehicle number]", acformedit

I am overlooking something. This way when vehicles are added I don't have to change the code.

 

[mcadle]

nevermind I am retarded

DoCmd.OpenForm "fleet2", , , "[Vehicle Number] = forms![form2]![text2]", acFormEdit

Thanks for all of the patience and help Pat. I think this will make it easier and quicker.