in-line function load question

S

Stephen

I have a form with a subform that is based upon an in-line function.

The user enters a search string (strSearchField) on the form and then this
is used as the search parameter in the in-line function.

The functions and forms work well, except that when the form and subform
load/open for the first time, the system is asking me for the strSearchField

I have been looking at why this occurs and I cannot figure it out.

I have tried to set the recordsource of the subform to "Me.RecordSource =
"SELECT * FROM fctAccountSearchResults(' ')" in the subform's OnOpen event
and this doesn't work

I have tried to set the recordsource of the subform to "Me.RecordSource =
"SELECT * FROM fctAccountSearchResults(' ')" in the subform's OnLoad event
and this doesn't work

When the form/subform open, I want the subform's resultset to be empty. How
do I do this?

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

MS ACCESS: SEARCH in a split form 0
VBA code returns no records hwenKey ID is added 14
Access ADP Form and Stored Procedure as RecordSource Options 2
VBA Syntax for subform record source change 6
change subform label backcolors function 1
Referring to control in the active subform 0
Waiting for subform to load... 1
Can't change recordsource in Form_Open in Access 2007 1

Top