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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime-Error 40036 3
Run-time Error '40036' 1
Runtime error 2501 3
runtime error 3
Forms Methods 4
Change form design via VBA 3
Runtime error 2001 2
VBA execution order 0

Top