Criteria Coding in queries

N

Noel

There is a code in the Criteria field and I am trying to figure out what it
is doing. Could you help me? The criteria is under the SPID field

[Forms]![frm Service Purchase]![subfrmServicePurchase]![SPID]

Thanks
 
T

tkelley via AccessMonster.com

It is using a value in a control (likely a textbox) called [SPID], on a
subform called [subfrmServicePurchase], on a form called [frm Service
Purchase] as the criteria for that field in the query.

There is a code in the Criteria field and I am trying to figure out what it
is doing. Could you help me? The criteria is under the SPID field

[Forms]![frm Service Purchase]![subfrmServicePurchase]![SPID]

Thanks
 
Top