If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Binding a textbox to a single record in a table.
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 |
#2
|
|||
|
|||
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. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Andy" wrote in message ... 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. |
#3
|
|||
|
|||
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. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Andy" wrote in message ... 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. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating a multiselect field in a form to populate a single field in a table | Conni | Using Forms | 1 | September 21st, 2004 05:58 PM |
How do I copy the LAST RECORD of one table onto another TABLE? | JANUS1356 | General Discussion | 2 | September 9th, 2004 11:08 PM |
Autonumber | Ally H. | General Discussion | 7 | August 27th, 2004 04:51 PM |
save ~50,000 record table sorted from one million record table | Pete317 | Database Design | 3 | June 20th, 2004 04:52 AM |
Update query based on value in a different record of the same table | Dale Peart | Running & Setting Up Queries | 2 | June 9th, 2004 12:53 AM |