delete

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

- 15 Sep 2004 00:36 GMT

From: <ria@discussions.microsoft.com>
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

Reply to this Message

mscertified - 15 Sep 2004 01:01 GMT

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.

> From: <ria@discussions.microsoft.com>
> Subject: form linking
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message

PC Datasheet - 15 Sep 2004 01:50 GMT

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
resource@pcdatasheet.com
www.pcdatasheet.com

> From: <ria@discussions.microsoft.com>
> Subject: form linking
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message