var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Referencing subform recordsource error 2001
im trying to change the record source for a subform based on a selection made from a dropdown on my main form:
problem is i get error 2001 'you cancelled the prvious operation'
Private Sub Student_AfterUpdate()
Me.TravelMaster.Form.RecordSource = sQl
when ever i update the combo box- im pretty certain im referencing the subform properly.
here are the details
main form - master
mainform drop-down: student
anyone know what is happening im pretty sure ive done it just like this before and it's worked- am stuck- none of the stuff ive found on google answers this
Forms!MainFormName!SubFormName!FieldName = sQ1
it's not a field it's the record source of the subform.
Try with RecordSource instead of Fieldname.