Combo Box to take user to Form

P

Polina

I want a user to select a value from a combo box which
will then open the form with only the value the user
selected any help is great
 
R

Rebecca Riordan

Two techniques:

1) Base the query on a parameter query and pass the value of the combo box:

Forms!<formName>!<cboName>

where <formName> is the form containing the combobox, and <cboName> is the
name of the combobox control.

2) Set the filter of the form based on the value of the combobox (same
syntax).

HTH

--
Rebecca Riordan, MVP

Seeing Data: Designing User Interfaces
Designing Relational Database Systems, 2nd Edition
www.awprofessional.com

Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
www.microsoft.com/mspress
 
Top