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
S.Y.M. Wong-A-Ton - 31 Jul 2006 12:59 GMT
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
> Hi,
>
[quoted text clipped - 10 lines]
>
> Jakob