Form_Load Event

[Juan4412]

Private Sub Form_Load()
    changeSource Me.AccountName, Me
End Sub

Account Name is a textbox on my form that is populated manually. I want the source of the form, to change depending on what is input into that text box, but I get this error:

error
sub or function not defined




What did I leave out?

[Bob Fitz]

Hi

What is "changeSource"

[Juan4412]

What I am trying to make the code say is "change source" change the recordset of the form to Me.AccountName which is a textbox on my form called AccountName

[pbaldy]

Well, you've made up a function that Access has no knowledge of, hence the error. You'd want to change the record source property:

Me.RecordSource = "QueryNameOrSQL"

It is unlikely that setting it to the account name textbox would work, unless it contains the name of a table or query in the database.

[Juan4412]

OMG!! I have been banging my head against the wall all darn week because of this, I forgot we pulled a backup and the backup didn't have the module in it that called changeSource!

Thank you!!!!!!!!!!!!!!!!!!!!!!