containers,collections,objects

Topic

New Reply

Using Access97 SR2
I want to set the ‘Source’ property of an existing form to an arbitrary value before opening it. Somehow I’ve convinced
myself that some invocation involving containers / collections/object(s) can do this. Has anyone out there solved this or a similar problem? Whatever documentation I’ve looked at has me boggled.

Reply | Quote

Replies

What do you mean by ‘set the ‘Source’ property of an existing form to an arbitrary value’? Are you referring to the RECORDSOURCE?

Reply | Quote

You can set the RecordSource property using VBA.

First load your form hidden.
Then set the recordsource with forms![frmMyForm].RecordSource = “MySQLStatement”
Then Refresh the form
And finaly make the form visible.

Reply | Quote

Many thanks … however when I run the following

grab1: who = Mid$(mycursor, 41, 6)
sqlTxt = “SELECT dumpmast.*, * FROM dumpmast ” _
& “WHERE dumpmast.empNum = ” & who & “;”
DoCmd.OpenForm “nachamatcher”, acDesign
Forms!nachamatcher.RecordSource = sqlTxt
DoCmd.Close acForm, “nachamatcher”, acSaveYes ”’ grab1 works to here
DoCmd.OpenForm “nachamatcher”, acNormal ****
Set frm = Forms!nachamatcher

the starred line produces Runtime error 2501

” the OpenForm action was cancelled

You used a method of the DoCmd object to carry out an action in VB but then clicked Cancel in a dialog box.

For example, you used the Close method to close a changed form, then clicked Cancel in the dialog box which asked if you want to save it. ”

What have I done wrong?

Reply | Quote

Just trap the error and ignore it. This is one of those annoying event-related messages that usually doesn’t mean anything except that you didn’t do things in the order Access expected.

Reply | Quote

Yes, I can trap the error but how do I (re-)open the form?

Reply | Quote

Sorry, I must have missed something. Why are you closing it in the first place? You needn’t open the form in design view to set its recordsource, you can do that at runtime. And you don’t need to save anything if you’re going to run this whenever you open the form. If you want to save a specific recordsource, the simplest way is to do it in the design view and skip the code part.

Reply | Quote