Cascading Fields in a form

[tomrector]

Acesss 2002 WinXP Sp2 lots of space, lots of ram

I have a database for ticket sales. 3 tables, Events, Venue, Sales. On
the Sales table input FORM I have a field VENUE set as a combo box
with row source as
SELECT Venue.ID, Venue.venu FROM Venue ORDER BY Venue.venu;
This just to have a picklist of venues from a table. The field "Venue"
is also in the Sales, and the Events tables, so I purposedly left the
"e" off the field name in the Venue table.

In the same form I have a field EVENT set as a combo box with row
source as. SELECT DISTINCTROW Events.ID, Events.EVENT FROM Events
WHERE (((Events.Venue)=Forms!Sales1!Venue));

My intention is to have a pick list of Events at the Venue selected
above, that will eventually be used as data for sale of a ticket to
that event, the Event table also has
pricing data that I will need to match by distinctrow also and pass to
the Sales table.

My problem is that the combo Event field will not list the events
associated with the venue. I have included a refesh of the Venue field
"after Update" .
Any suggestions out there, I certianly would appreciate the help.


Tom Rector

 

[Ken Sheridan]

Tom:

You need to requery the Event control in the Venue controls AfterUpdate
event procedure:

Me.Event.Requery

Ken Sheridan
Stafford, England