Recent content by down on the upside

you guessed it, both fields were text and yes your code works, thanks!

hmm I updating the quotes but I might not be using the quotation marks correctly still coding below: DoCmd.OpenForm "Record Review and Update", , , [dbAFENumber] = "& Me![txtMMdbAFENumber] & AND [dbPeriod]='" & Me![txtMMdbPeriod] & "'"

I am attempting something similar to SDM and have got it to work with one issue, when I use the command button to run the macro it opens up a message box asking for the value to be entered instead of referencing the control. The message box happens to reference the control. It is the first part...