delete

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

From: <[email protected]>
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.
 
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.
 
Back
Top