Query from a form unbound field (1 Viewer)

naobao

Registered User.
Local time
Today, 14:02
Joined
Feb 13, 2014
Messages
76
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: 56
  • 1a.png
    1a.png
    47.5 KB · Views: 42
  • 2.png
    2.png
    79.3 KB · Views: 53
  • 2a.png
    2a.png
    33.9 KB · Views: 47
  • 2b.png
    2b.png
    21.7 KB · Views: 54

isladogs

MVP / VIP
Local time
Today, 22:02
Joined
Jan 14, 2017
Messages
18,209
On the form just enter the value 1903
In the query, use Like Forms!Buckle.Order & "*" or similar.
 

Users who are viewing this thread

Top Bottom