runtime error '40036' - Method 'Item' or 'Forms' failed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm building a search function and the form 'Resultsform_Source' should return the located records.
In order to do this I want to change the recordssource form the subform - 'Overview Results' on it which will hold the actua
data. (This since the user has to fill in the wanted object in a textbox.

When I open the form runtime and try to change the recordsource I receive a runtime error:
runtime error '40036' - Method 'Item' or 'Forms' faile

What am I doing wrong

Here is my code
DoCmd.OpenForm "Resultsform_Source
DoCmd.SelectObject acForm, "Resultsform_Source
Forms![Resultsform_Source].RecordSource = querySt
Forms![Resultsform_Source].Form![txtObjectChoice].SetFocu
Forms![Resultsform_Source].Form.Caption = "Parent objects

Thanks for any help
 
Back
Top