Unanswered: Problem referencing field in query from tab controlled form
I have a Tab Controlled form, which I have copied several different forms onto their corresponding tab pages. One of the fields on one of the forms calls an append query. The criteria for the append query is equal to a field on the tab page that opens the query.
The strange thing is that before I copied the form onto the tab controlled form, this query worked perfectly. Once I copied the form onto the tab controlled form and changed the criteria in the query to the new form information, it stopped working.
The criteria to reference the field in the original form is:
The criteria to reference the field in the new Tab Control Form is:
I've tried this also without the [Attendance List] part (which is the page name) as well without success. And with just [CycleID].
If I understand you correctly, you pasted a form inside the page. Thus you have to refer to the name of the form you pasted in the page after the page name. IE [forms]![form name]![Page name]![subform name]![control name].
I have not done it in a couple of years, back during office 97. But I believe it is how I accomplished it.