bradleyhorn
Technical User
Hi All,
I am having some trouble with a linked form. This form(2) is opened from another form(1) which lends it the parameter called "casenum". The second tabular form should open up and show all the records with the related "casenum". Now when the form(2) opens up all the data fields are grey. They don't even look like fields, they are just blank. The linked form(2) is basd on a query, that should choose the right "casenum":
SELECT zMoreServiceToParents.CASENUM, zMoreServiceToParents.DateService, zMoreServiceToParents.TypeOfService, zMoreServiceToParents.ServiceGivenToWhom
FROM zMoreServiceToParents
WHERE (((zMoreServiceToParents.CASENUM)=[Forms]![inpChildrensProjectServiceTargets]![CASENUM]));
This form was fine when it was on an ACCESS database but quit working when that table was brought into SQL-Server. Any Ideas?
Bradley
I am having some trouble with a linked form. This form(2) is opened from another form(1) which lends it the parameter called "casenum". The second tabular form should open up and show all the records with the related "casenum". Now when the form(2) opens up all the data fields are grey. They don't even look like fields, they are just blank. The linked form(2) is basd on a query, that should choose the right "casenum":
SELECT zMoreServiceToParents.CASENUM, zMoreServiceToParents.DateService, zMoreServiceToParents.TypeOfService, zMoreServiceToParents.ServiceGivenToWhom
FROM zMoreServiceToParents
WHERE (((zMoreServiceToParents.CASENUM)=[Forms]![inpChildrensProjectServiceTargets]![CASENUM]));
This form was fine when it was on an ACCESS database but quit working when that table was brought into SQL-Server. Any Ideas?
Bradley