Common tasks SP

How do I open a form from another form? ( Button click, menu item )

How do I filter a result set based on a value from a drop down list box?

How can I use a combo box to select values, but allow the user to update the list of available choices?

How to add a sub form to a sub form?

How to display a summary ( aggregate ) field for all the records in a table grid control, that updaes when records are added or updated?

How to set up a field that displays a calculated value based on the entry from other controls? ( display only & how to save this value )

How would I use a value entered in a control to update a batch of records in the database?

How to limit ( alter ) the list displayed in a list box when an item is selected in another list box?

How do I display values from more then one column in a list ( combo ) box?

How do I programmatically copy a record's data to a new record, allwoing for some columns to be changed before being written?