How do you run code when a form is opened? Can i embed the code in the form

Jame

The form has an On Open event. You can access it through the event
properties of the form.

--
Duane Hookom
MS Access MVP


"James" <(E-Mail Removed)> wrote in message
news:BF25038B-6F56-4790-B5F9-(E-Mail Removed)...
> How do you run code when a form is opened? Can i embed the code in the
form?
>
> James
>
>

On Mon, 24 May 2004 18:16:03 -0700, "James"
<(E-Mail Removed)> wrote:

>How do you run code when a form is opened? Can i embed the code in the form?
>
>James
>

Yes to both. Open the Form in design view, and view its Properties.
Select the Events tab, and click the ... icon by either the Open event
(which fires first, before the Form's recordset has been opened or any
of its controls populated; this event can be calcelled) or its Load
event (fires before the user gets control but after the controls have
been filled).

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public