list box search and results display on list box

issactang

I would like to make a query from
transactions to see the patron history by enter a barcode.
I have made a recordset to get the patron barcode
in the same time to get the Id field from patrons
as this value is connected to the [checked out to] field in the transaction.


I have tried
my result_list is a value list type
and it displays
ID book id checked in date checked outdate due date

in the first line without my search results.

did i miss anything ?
thanks.

Jan 7 '12 #1

issactang

i tried to do this

but still no record is displayed

Jan 7 '12 #2

Rabbit

That's because if you want to use a query as a row source, you can't use value list as the type.

Jan 7 '12 #3

issactang

i used table/ query
and used a wizard to help me configure the query instead with cross table.

and add the following code.

Jan 7 '12 #4