Query from a form unbound field

naobao

Registered User.
Local time
Today, 10:02
Joined
Feb 13, 2014
Messages
99
Hi,


I can't run a query record, when I lookup from a form unbound field


Picture1 & 1a is OK by the criteria like "1903*"


But in Picture2 , 2a & 2b,it does not seccess
 

Attachments

  • 1.png
    1.png
    33.4 KB · Views: 99
  • 1a.png
    1a.png
    47.5 KB · Views: 81
  • 2.png
    2.png
    79.3 KB · Views: 97
  • 2a.png
    2a.png
    33.9 KB · Views: 89
  • 2b.png
    2b.png
    21.7 KB · Views: 97
On the form just enter the value 1903
In the query, use Like Forms!Buckle.Order & "*" or similar.
 

Users who are viewing this thread

Back
Top Bottom