list box

[Tracy]

Hello,

I'm sure there's a way to do this, but I give up....

I need to populate data into a listbox that is in a sub form...

This is a project in Access....

*****
If you open the project up you will see a form with menu...
Select Event participation from this menu and a form will pop
up, this is where my problem is....

In the invoice field, I want to populate all available invoice text from table InvText into a listbox that will replace this field.
When user select an invoice from this list, then I need to update
the current record to the selected invoice text...

I know this is a lot, but please help.....

[M Owen]

Let's see some code ... That will help figure out what is not going right for you ...

[Tracy]

I've attached the whole program....

It's in Access 2000....

[Tracy]

I can't attach my Access application, it's too big...

Is there anything else I can do?

[M Owen]

Yes ... Try copying and pasting your code here ...

[Tracy]

I only have the query used to load data onto this form...
Everything else is bounded to this query....


SELECT Attendee.EventID, Attendee.InvoiceID, Attendee.Event, Attendee.Type, People.Last, People.First, People.MI, InvText.InvoiceText, Attendee.AttendeeID, Attendee.PeopleID, InvText.EventID
FROM People INNER JOIN (Attendee INNER JOIN InvText ON Attendee.InvoiceID = InvText.InvTextID) ON People.PeopleID = Attendee.PeopleID;