Combox Filter

[Guest]

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;

 

[Guest]

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]

 

[Guest]

Thank you for the reply

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

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;