H
hughess7
Hi all
I have made a form a subform and one of my queries has stopped working. I
know how to reference a subform and I have changed the syntax to this in
several places but one of my queries still won't work. I've used the same
syntax that works in another query so I am not sure why it won't work? I even
copied and pasted it so should be no typos! The differences are the control
is in the footer of the subform rather than the detail, it is an unbound
control and holds a date value.
This works ok in query criteria:
[forms]![frm Itinerary]![Itinerary].[form]![ItineraryID]
This doesn't work:
[forms]![frm Itinerary]![Itinerary].[form]![StartDate]
Access complains it does not recognise it as a valid field or reference, I
thought it would normally prompt for a parameter to be entered if it was
incorrect?
Kind Regards, Sue
I have made a form a subform and one of my queries has stopped working. I
know how to reference a subform and I have changed the syntax to this in
several places but one of my queries still won't work. I've used the same
syntax that works in another query so I am not sure why it won't work? I even
copied and pasted it so should be no typos! The differences are the control
is in the footer of the subform rather than the detail, it is an unbound
control and holds a date value.
This works ok in query criteria:
[forms]![frm Itinerary]![Itinerary].[form]![ItineraryID]
This doesn't work:
[forms]![frm Itinerary]![Itinerary].[form]![StartDate]
Access complains it does not recognise it as a valid field or reference, I
thought it would normally prompt for a parameter to be entered if it was
incorrect?
Kind Regards, Sue
