| | |
|
|
|
Lookup Field |
|---|
| message from =?Utf-8?B?TUo=?= on 18 May 2004 |
I have a table with a lookup field that is pulling rows from another table. The table with the lookup field and table that provides the lookup field values are connected by the index of a third table. Anyone know how to limit the number of rows that show up in the lookup field based on the particular index (to the third table) in that current record?
In other words, is there any way to get the value of a field in the CURRENT record, the record where the user is using the lookup combo box?
|
| John Vinson replied to =?Utf-8?B?TUo=?= on 18 May 2004 |
As far as I know, you CANNOT do this in a table datasheet.
However, it's quite straightforward to do so on a Form, and you should
be using Forms for your data interaction anyway. Table datasheets have
*very* limited capability, and the Lookup field type is even more
limiting.
For an example of code to create a dependent combo box on a Form, see
http://www.mvps.org/access/frm0028.htm - use the second example on
that page.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
|
Archived message: Lookup Field (MS Access Error Message)
