Populate List Box Help

[jboomer]

Hey guys i need some help i am almost finished with a datbase but can't seem to get the filter to work.

Here is the deal

I have 2 tables: First table is Called "IEPMeetings" and the second is called "Tasks"

Each table has an ID field that coresponds to the table, such as "MeetingID" and "TaskID"

The second Feild in the Table "IEPMeetings" is called "Meeting Tasks" and it is a lookup Field with "SELECT [IEPTasks].[TaskID] FROM IEPTasks;" as the row source

So when I open up the table it shows the drop down with just the TASk ID number displayed.

I have a form called "Meetings" that has all the fields in the form . I created a list box with ROW Source-

SELECT IEPMeetings.[Meeting Tasks].Value, IEPTasks.Task FROM IEPTasks INNER JOIN IEPMeetings ON IEPTasks.TaskID=IEPMeetings.[Meeting Tasks].Value;

This shows The Task in the list box but it shows all the Tasks that are in the IEP Tasks Table.

What I am trying to do is just show the tasks that have been assigned to the IEP Meeting.

Please help, let me know if you need more information.

I thought i could do this by using a marco "Apply Filter"

 

[kurtis51]

Might want to try the simpiler route:
Create a Lookup to the Tasks table and sort ascending by the Task rather than the TaskID first

 

[jboomer]

Might want to try the simpiler route:
Create a Lookup to the Tasks table and sort ascending by the Task rather than the TaskID first

Not sure what you mean. I tried to creat a lookup on the meetig table to the task name and it has the same problem. The list box show all records in the IEPTask Database.

 

[kurtis51]

Not sure what you mean. I tried to creat a lookup on the meetig table to the task name and it has the same problem. The list box show all records in the IEPTask Database.

Sorry I've been working with linking multiple tables recently, the common problem I see is that when you do a Lookup from one Table to another, that Access always adds the Primary Key (TaskID) to the first Lookup Column, rather than the column you are trying to retrieve information on (Task).

So you are in the Lookup Wizard;
You have selected your Tasks Table and you select your field Task.
The next screen is your Sort By this is where you would select your field named Task rather than your TaskID. Even if left Blank it will automatically select your TaskID.

 

[jboomer]

I tried that. The List box behaves the same way.

Maybe i didn't make myslef clear. the list box in the form. still shows all records from the IEPTasks Table. but i only want it to the tasks from the IEPTasks Table where the [IEPMeetings].[Meeting Task.Value]=[IEPTasks].[TaskID]. But te fliter doesn't seem to work in the Form no matter what i do or change in the table.