Still kind of new to this, I hope this helps... Your code posted for your control source is:

.Text1.Controlsource = "(IIF( SEEK( tqDispatch.pcDrv_id, 'driver' ), driver.lastname , '' ))"

In this instance, you are missing a field for your seek. "tqDispatch.pcDrv_id" is the Value you are looking for. Inside a table called "driver"....

it should be something like:

IIF(SEEK(tqdispatch,"pcdriv_id","driver")

where tqdispatch is the value that you are loking for inside the table "pcdriv_id", which has been indexed and tagged as "driver".


Am I thinking correctly?




>I am wondering if this is a bug or if I've just spent too many hours in front of this screen.
>
>I'm trying to utilize some of Marcia Akins' combos in grid ideas and part of the code utilizes the SEEK() function but I can't get it to work properly.
>
>So I tried a simple test.
>
>Opened two tables, TableA & TableB.
>
>Have TableB selected.
>
>Issued the following command in the command window:
>
>

>SEEK(value,'TableA','TableA IndexTag')
>

>
>I receive the error "Function name is missing )". Am I just too tired or is this a bug?
>
>If I select TableA and issue the command:
>
>

>SEEK(value)
>

>
>This works just fine.
>
>TIA,
>-Sid.