S
Sash
Is it possible to put criteria in a form's Control Source. For example, I
have a query that has fields LINE and LINETYPE. I want the form to have two
field:
FIELD1 - Populated with LINE where LINETYPE = "DESC"
FIELD2 - Populated with LINE where LINETYPE ="PRE"
Any advice on the best way to handle this?
have a query that has fields LINE and LINETYPE. I want the form to have two
field:
FIELD1 - Populated with LINE where LINETYPE = "DESC"
FIELD2 - Populated with LINE where LINETYPE ="PRE"
Any advice on the best way to handle this?