Try looking into this article:
http://enterprise-solutions.swits.net/infopath/query-access-database-list-numbers.htm
It modifies the SQL statement of a form by adding a WHERE-clause to it that
is composed of values from a field on the form.
---
S.Y.M. Wong-A-Ton
"JRohde" wrote:
[Quoted Text] > Hi,
>
> I am trying to create a form that has a projekt number field on the
> main page. There is a button, that shows another view containing
> project data based on what project number the user has typed in the
> projekt number field.
>
> I have managed to create a condition with an SQL clause, but I need to
> add a "where-clause" besed on the project number field. How do I
> reference this form field in the SQL statement?
>
> I hope I'm making sense here...
>
> Jakob
>
>
|