G
Guest
I have a table with 5 text boxes named: Value1, Value2, Value3, Value4, Value5.
I have a query with 5 rows. One of the column names is CardNumber.
Setting Value1 equal to Cardnumber in the first row of the query is easy:
Value1 = DLookup("[CardNumber]","[QueryName]")
How do I get Value2 = to CardNumber in the second row of the query,
Value3 = to CardNumber in the third row of the query,
Value4 = to CardNumber in the forth row of the query,
Value5 = to CardNumber in the fifth row of the query.
Please help.
Thanks
I have a query with 5 rows. One of the column names is CardNumber.
Setting Value1 equal to Cardnumber in the first row of the query is easy:
Value1 = DLookup("[CardNumber]","[QueryName]")
How do I get Value2 = to CardNumber in the second row of the query,
Value3 = to CardNumber in the third row of the query,
Value4 = to CardNumber in the forth row of the query,
Value5 = to CardNumber in the fifth row of the query.
Please help.
Thanks