Cascading combo box help?

[morfusaf]

Ok,

I have 3 tables, event, person, and personat event...

I have a junction table linking it all .. .

All that works,


Currently I am working on an formUpdateEvent.

I want to start out by choosing the date of the event, cboDate (I need the date to be selected from DetailDate field)


then I want the 2nd combo box to only shot events that happened on that date... cboEvent and the event chosen from the DetailEventTitle field.

Both are in the table tblEvents


Using MS Access 2007

I NEED Exact details... people keep saying just use this code, or blah blah... i don't know where to put the code, or how to get to where I need to.


So, please be exact as you can ... thanks!


Also, once I get the combo boxes to select correctly.... I want the second combo box to populate the rest of the form so I can update the event as needed.

 

[jdraw]

see free video tutorial here
http://www.datapigtechnologies.com/flashfiles/combobox2.html

also
http://www.baldyweb.com/CascadingCombo.htm

 

[morfusaf]

Ok, I got the combo boxes to work...

Now for part too...

Once I select the Event in the 2nd combo box, I want that to populate all the fields on the form, according to what that event had.

So I I select the date, then the event on that date, and all the information populates accordingly, and I can change what is needed then save Record.

What I am currently doing isn't workin...

Basically I just copied the afterUpdate macro from one of comboboxes that populates the form (made from the wizard).

I copied the macro action SearchForRecord and the Record below is First and the Where Condition is ="[EventID] = " & Str(Nz([Screen].[ActiveControl],0))

I have no idea what that means but it seems to work for the other one..

 

[jdraw]

I am not familiar with macros.

If you have a query as the recordsource for your form, it sounds that you need to use the value selected from the combo in a where clause on the recordsource to restrict the records to the current event date.

Don't know if that helps, but that's what I got from your description.

 

[morfusaf]

The date isn't my issue,

I just want to populate the form, with the selected record, from my 2nd combo box(event name)