Binding a textbox to a single record in a table.

[Andy]

Hi,

Can anyone tell if it is possible to binds a textbox on a
report to show the value of a single record in a table?
If it is possible, please tell me.

Thanks

Andy

 

[Allen Browne]

If you want the text box to lookup a field in a table that is not in the
report's RecordSource, use DLookup().

Details:
Getting a value from a table: DLookup()
at:
http://members.iinet.net.au/~allenbrowne/casu-07.html

 

[Andy]

Nice one.
Works great.

Cheers.

-----Original Message-----
If you want the text box to lookup a field in a table that is not in the
report's RecordSource, use DLookup().

Details:
Getting a value from a table: DLookup()
at:
http://members.iinet.net.au/~allenbrowne/casu-07.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.