Reference recordset field name with VBA (1 Viewer)
- Thread starter jkfeagle
- Start date
boblarson
Smeghead
- Local time
- Yesterday, 19:06
- Joined
- Jan 12, 2001
- Messages
- 32,059
Yep, that's another completely valid, and probably more used, way.
What if I wanted to use !Customers as a paramater for some function, but its possible that the table does not contain that particular field?
example
with rst
' some code
value = someFunction (param1, param2, !Customers)
end with
However, sometimes !Customers is not part of rst in every case. (users can choose which fields they want)
I tried using an IIF to check if the table had the field, looked something like
'(hasfield() is a function written by my predecessor)
value = somefunction(param1, param2, _
IIF(hasField (theTable, Customers), !Customers, "")
This did not work, always got "Not found in collection" for !Customers
Any ideas?
Thanks
example
with rst
' some code
value = someFunction (param1, param2, !Customers)
end with
However, sometimes !Customers is not part of rst in every case. (users can choose which fields they want)
I tried using an IIF to check if the table had the field, looked something like
'(hasfield() is a function written by my predecessor)
value = somefunction(param1, param2, _
IIF(hasField (theTable, Customers), !Customers, "")
This did not work, always got "Not found in collection" for !Customers
Any ideas?
Thanks
Similar threads
