Search results

Yeah, I've had trouble getting this right myself. My understanding is that the ObjectName refers to the name of the form itself not the name of the control for which the form is the SourceObject (but I could be wrong). If all else fails you might try putting the code inside the subform itself...

A multiselect list box is what you need, but be aware that it will require code to update the proper table. To do the "Other" thing, you will need to do something like this: - Include "Other" as just another selection in your list box; - Add a new column in the table, let's call it "Specify"...

Try something like this in your OnCurrent event: DoCmd.GoToRecord acDataForm, "Employees", acLast Bill Norton Austin, TX

First of all let me correct a coding error. To change a subform's RecordSource try this: Me.mySubFormName.Form.RecordSource = "SELECT X, Y, Z, FROM ... WHERE " & lsWhereClause Now, when you say that changing the SourceObject for an existing subform is considered a design change, are you...

Go with Mike's approach, and perhaps set the subform's RecordSource at the same time: Me.MySubFormName.SourceObject = "NameOfForm" me.mySubFormName.RecordSource = "SELECT X, Y, Z, FROM ... WHERE " & lsWhereClause Me.MySubFormName.Requery Your usere will NOT need any kind of special priviliges...

Before we go to far here let's make sure you're not sending your colorful report to a black and white printer. Other than that, most controls have a ForeColor, BackColor and BorderColor which you can set to anything you want. Bill Norton Austin, TX

Are you actually trying to move the subform to a different spot on the form? Well, this would do it: Me.sfWhatever.Left = 2000 The number you are setting it to is in twips, I believe. Bill Norton Austin, TX