Filtering results from a table

[Rocky_Lad]

Hey,

Have a slight problem, im trying to filter things from a table to be put onto a report. I can't think of a way to do it, ive looked around and cant see anything..

any ideas?

Thanks

[Br1an_g]

is this Access?

if so, create a query that does all of the filtering for you, and base your report on that.

or if you want to base your report on the table you can use the filter criteria of the openReport method:

DoCmd.OpenReport "MyReport",acviewPreview,,"[Filter Field] = 'Filter Criteria'"

HTH

[Rocky_Lad]

Itn is access

this is a restaurant ordering system, and the orders are linked by table numbers. I am trying to bring up all entries from said table that have the same table number, selecting the number from a combo box. I couldnt figure out how to do this with a query.

[Br1an_g]

yeh, wouldnt bother with the query.

use this for the After Update of hte combo box:

Private Sub cboMyCombo_AfterUpdate()
 
DoCmd.OpenReport "Report Name",acViewPreview,,"[Table Number]=Forms!frmMyForm!cboMyCombo"
 
end sub

this opens a report called 'Report Name' in preview mode , where the field 'Table Number' equals the value in the combo box cboMyCombo