on a form on a specific record

[biscuitboy]

Hi,

I have two forms one is called administration and another is called Workgroup. Basically I have a textbox on the administration form called text23 and what I would like to do is when a value is in this field and a button is pressed I want the Workgroup form to appear showing the record, dependent on the value in text23. This is a simple code and it has worked a number of times before. However this time it doesnt seem to want to work.

The code I am using is:

DoCmd.OpenForm "Workgroup", acViewNormal, , "[Text12]='" & Me![Text23] & "'"

Any ideas,

Best regards

Buscuitboy

 

[fumei]

If it has worked before, what is different (other than the result) this time?

Gerry