Passing Navigation Combobox ID to Listbox Query?

[thadius856]

My form has a combo box for navigation. I accepted the wizard's output because it seems to work just fine without requiring fiddling.

cboJumpRecord:


Lower in the form, I have a listbox for showing past transactions on that item. It uses a query as its rowsource. Right now it shows ALL records in the transactions table. I'd like it to show only the entries for the current record.

I figured this would be as easy as adding a criteria to the query...

Field: MediaItemID
Table: tblMediaItems
Criteria: [Forms]![View Library]![cboJumpRecord]

...but of course that returns no results.

I've fumbled around with it for hours, but not finding any combo that returns results. Where am I going wrong?

[June7]

You are describing combo and/or list boxes. http://www.datapigtechnologies.com/f...combobox2.html

Listbox RowSource:

SELECT fieldname FROM tablename WHERE somefield=[cboJumpRecord];

Then need code to requery the listbox. Try the combobox AfterUpdate event.

Me.listboxname.Requery

[thadius856]

Ahhh. I'd already done everything except put in the requery.

Thanks!