open a form (1 Viewer)

[playtime38]

I have sent this query to Lynda but do not expect a reply as there are probably too many hackers asking stupid questions of them, but it is easy to build the code from his movie, but he does not give you instructions on how to get the open a form module - he opens the exercise files with this already in but if I want to construct a model myself can anyone tell me how to do it. i have atttache a .png of the open.

SUBJECT opening a form - how do you get to the display products form button?
MESSAGE I am wanting to do this im my database3.acccd - creeating myself. You open video with module pre existing, but how do you get to design view button.(Curtis Frye form Lynda up and running with access vba)
First go to the products form and open in design view - click rt and it comes up with build event - how do you create this view?? It goes on in cap 6 -
select code builder and it opens the vba editor showing the code ready to put in. Thanks for your help

 

[Cronk]

Have you tried right clicking on the form in the Navigation panel and selecting Design View?

 

[playtime38]

Yes I have thanks Cronk - but I am unable to make any sense of it yet from the properties. Perhaps when I know more I will be able to understand. one of the references you referred me to wrote something about a macro to open a form, and Lynda Curtis said something about a macro at the beginning of the movie, and I have been back to cap1 about macros by him but there is nothing of the vein I am looking for. I have enclosed a pic of the module opened in design view for you to see

 

[AccessBlaster]

You can't skip over the basics of relational database design because now you need a module.

 

[playtime38]

Yes Cronk was correct - it is a macro with the DoCommand

 

[Cronk]

To come back to your original question as how to open up a Form's code module, the quickest is once you have the form in Design view (as per your Capture4.png), click on the Design tab and select View Code in the Tools tab.

But I think you have a lot of learning about Form events before you get too far. Don't get discouraged - anyone past the beginner stage in Access has gone down the same road.