Access 21 problem with where command

[ChrisLeicester]

Hi
Thanks for the feedback.

I will change the Dcount to not use the strings. I did that as a first to copy the syntax so I ensured I followed it.

Where are you getting the ProdOrderID will be null.
I was intending that the where command should be where ProdOrderID is equally to the POSelected which is the text box that the user enters the PO number they want to load.

I thought that POSelected only changes to null if no records are found and that command then clears the incorrect number so the user can try again.

 

[Isaac]

I literally won't even try to read unformatted code, it's too much brain energy lost