Query with parameter in form drop down field

S

Stukmeister

I have the follwing Query: "Event Type Q1"
SELECT [Event Type].EventTypeID, [Event Type].EntryTypeCategory,
[EventType].EventTypeDescription
FROM [Event Type]
WHERE ((([Event Type].EntryTypeCategory)=[Category]))
ORDER BY [Event Type].EntryTypeCategory;

Table Event refers to table Event Type.

I have a form "Maintain Event" that has a dropdown field EventTypeID and
EventCategory. I want to pass the EventCategory to "Event Type Q1" to select
only the records equal to EventCategory.

How can I do that?
 
D

Dirtbike

Create a query with a parameter of [Forms!YourFormName.EventTypeID]
you might need a Me!Refresh in the on update of the form to make it work.

I do NOT know the difference betrween the bang (!) and the dot (.)...maybe
someone will enlighten.

The query becomes the control recordset of the form...if your record set
starts with a table, then hack SQL into the control source of the form.

...confused? I wish we could cut-n-paste screen shots because that's my
world....i can't hardly communicate without screen shots.
 
Top