How to populate subform with another criterion

[zx3]

Hi all,



I have this project Database1.zip which use a form to list individual salesperson's amount made in a specific time range, when enter a salesperson say "a" (a to e to choose from) then click search button, the salesperson's amount(s) will be listed. And when you click the date listed(click inside the box with the date), the sales journal on the same form are supposed to list the amounts made on that date regardless of salesperson.

My problem is i can only populate the subform (sales journal) with just one line, not all the amounts made during the same date, please help.

[ranman256]

Change the subform default view property to CONTINUOUS FORMS or DATASHEET.

[zx3]

Thanks ranman256 for your suggestion, but i got error return by this line

Me.Child17.Form.DefaultView = 1

run-time error '2136':
To change this property, open the form or report in design view

is there other way to set the default view?

[ItsMe]

Some properties need to be set before the form is opened. This may very well be one of those properties. In other words, even the On Load event may not be soon enough. If you were to attempt this via VBA you would probably have to open the subform in design view and hidden, then apply VBA code to adjust the default view, Save Changes and close the form. This type of VBA requires a full version of Access because this type of VBA will not work during Run Time.

If you need the subform object to be available as a Subform and available in both DS view and Single Form view. Suggest creating two objects, one for each purpose.

[zx3]

Thanks ItsMe for your suggestions, could you explain more about this,

If you were to attempt this via VBA you would probably have to open the subform in design view and hidden, then apply VBA code to adjust the default view, Save Changes and close the form. This type of VBA requires a full version of Access because this type of VBA will not work during Run Time.

and this

If you need the subform object to be available as a Subform and available in both DS view and Single Form view. Suggest creating two objects

I think i got full version of Access and i m not good enough to get subform updated at runtime, please help with the steps and code.

[ItsMe]

You do not get to choose what code works during Run Time and what code does not. Either the functionality you request utilizes Run Time or it utilizes something else, like design interface or Design Time (requires full version).

So, design your form. Design its default view property to Single Form. Save it. Make a copy by Right clicking the saved Form Object in the Navigation Pane. Paste your copy in the Navigation Pane. Give it a name. Open the copy( that has the new name) in Design View.

Assign the Default View Property of the second form as Data Sheet view. Save it.

Now, you have two form objects that can be used as subforms.

Use one when you desire DS view. Use the other when you desire Single Form view.

[June7]

A form can be opened in different modes but once it is open, cannot switch.

DoCmd.OpenForm "formname", acNormal

or

DoCmd.OpenForm "formname", acFormDS

This will not work with subform because it is the main form that is called to open.

I expect ItsMe's suggestion for alternate subforms is the only way to change the display mode of subform once open. Code would set the subform container control ControlSource property.

A compromise is Continuous View. Controls can be arranged to look like Datasheet or Single and can still scroll records.