Combox Filter

S

skk

Hello & thank you in advance.

Is there a way that you can filter the combo box? I want combo box value to
be filtered from the provious screen where user enter the value. if User
enter the value "X" then display only those "X" or if user leave the it blank
then disply the entire value.

Row Source: SELECT tblCust.CustID, tblCust.LastName, tblCust.FirstName FROM
tblCust;
 
O

Ofer Cohen

If the first form is still open, then you can add a filter to the field in
the first form

SELECT tblCust.CustID, tblCust.LastName, tblCust.FirstName FROM tblCust
WHERE FieldNameToFilter = Forms![Form1Name]![FieldName]
 
S

skk

Thank you for the reply

Ofer Cohen said:
If the first form is still open, then you can add a filter to the field in
the first form

SELECT tblCust.CustID, tblCust.LastName, tblCust.FirstName FROM tblCust
WHERE FieldNameToFilter = Forms![Form1Name]![FieldName]


--
Good Luck
BS"D


skk said:
Hello & thank you in advance.

Is there a way that you can filter the combo box? I want combo box value to
be filtered from the provious screen where user enter the value. if User
enter the value "X" then display only those "X" or if user leave the it blank
then disply the entire value.

Row Source: SELECT tblCust.CustID, tblCust.LastName, tblCust.FirstName FROM
tblCust;
Click to expand...
Click to expand...
 
Top