delete

From:
Subject: form linking
Date: Wednesday, September 08, 2004 12:23 PM

I have a form in which I have a list box (lookup table)in
the header and depending on the choice, I would like to
display records from another table. I am unable to
accomplish this. Could anyone help. I know this is very
basic..but I seem not to find much help.

Thanks

data from different tables or different data from the same table? How do you
want to display the data on a form or in a list?
Be more specific.

" wrote:


From:
Subject: form linking
Date: Wednesday, September 08, 2004 12:23 PM

I have a form in which I have a list box (lookup table)in
the header and depending on the choice, I would like to
display records from another table. I am unable to
accomplish this. Could anyone help. I know this is very
basic..but I seem not to find much help.

Thanks

Your form needs to be based on a query that has a field the same name as the
value of your listbox such as CustomerID. In your query put the following
expression in that field:
Forms!NameOfYourForm!NameOfYourListbox

Put the following code in the AfterUpdate event of the listbox:
Me.Requery

BTW The listbox must be unbound.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


wrote in message
...

From:
Subject: form linking
Date: Wednesday, September 08, 2004 12:23 PM

I have a form in which I have a list box (lookup table)in
the header and depending on the choice, I would like to
display records from another table. I am unable to
accomplish this. Could anyone help. I know this is very
basic..but I seem not to find much help.

Thanks