|
| 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
October 4th, 2004, 02:10 PM
|
|||
|
|||
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
October 4th, 2004, 02:37 PM
|
|||
|
|||
|
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
October 4th, 2004, 05:16 PM
|
|||
|
|||
|
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 |
Linear Mode
