Open 2nd Form with 2 criteria?

**Robeen** · 09-19-2011, 08:07 AM

Hi,

Is it possible to open a 2nd form from the current form so that the records on the 2nd Form satisy TWO criteria passed to it from the current Form?

Eg: I want to open Form2 with the Name on the current Form and with records that have yesterday's Date.

Thanks!

**pbaldy** · 09-19-2011, 10:20 AM

Sure, you just include " AND " between the two criteria.

Open 2nd Form with 2 criteria?

Thread Tools

Open 2nd Form with 2 criteria?

Similar Threads

To open a form, sub form if text box entry exist in Query

Open (sub)form linking 2 criteria on current form

Open multiple reports based on same criteria but with different queries

Code to check if form1 is open, then open then opoen form 2

Open form based on Subform criteria

Posting Permissions