In the Forms section, click Form Design.
You create a macro by using the Macro Builder, which is shown in the following illustration. To view and edit the VBA code: While the form or report is still open in Design view, if the property sheet is not already displayed, press F4 to display it.
Modules are composed of functions and subs procedures which perform the tasks you define. On the first page of the wizard, click each category in the Categories list to see which actions the wizard can program the command button to perform.
On the Event tab of the property sheet, click the event property box with which you want to associate the function. By clicking File, you can access menu items to save or open one: To return to the previous window, you can click the Back button.
When you use a database that was created by someone other than yourself, you should enable VBA code only if you know the database comes from a trustworthy source.
If you want to prepare the form to receive other objects, this is referred to as design. If the report is currently closed or it displays in another view, you can switch the view using the same techniques applied to a form.