Combo Box

[Pedro Magueija]

How can I make a combo box work as the navigational buttons??
I would like the combo box to list all records from a table and from there the subform would show the correspondent records from another table...

 

[WayneRyan]

Pedro,

Base your subform on a query. Include your combo boxes name
as the Criteria for the field to be searched. Reference it like:

Forms![YourMainForm]![YourCombo]

In the AfterUpdate event of your combo put:

Forms![YourMainForm]![YourSubform].Requery

Wayne