Filter on open question

[tomj]

Is it possible to set a filter to run when a form opens, based on the first value in another table?

My form displays customer orders. I want the form to open and only display customer orders from my customer_orders_table where the order_date is > a record_date in a Record_Date_Table. There is only 1 record in the Record_Date_Table.

 

[Fornatian]

Use a query as the recordsource for the form, the query having the criteria for the records set by a >=DLOOKUP() criteria statement.

Alternatively you could pass a Where clause in VBA which would have the same effect.

[DateField]>=DLOOKUP()