Access 2007 Tutorial 3.1. Forms and Subforms

In this video:
Form Wizard
Form Navigation
Creating a Form with Subform
Adding a Row Source for Comboboxes
Adding a Delete button
Subform Properties

Category:

Education

Tags:

• Form
• Wizard
• Navigation
• Creating
• Subform
• Row
• Source
• Combobox
• Delete
• button
• Properties
• Access
• 2007
• Microsoft
• Office
• Access 2010
• tips & tricks
• tutorial
• instructions

[giorgio89789]

This tutorial helps a lot, but it seems that this method will only allow you to select from the list of already established directors, but if you wanted to write a new director directly into the form (plus all other pertinent information), you wouldn't be able to because its actually the Director id field and not the director name.

I'm asking this because I'm wanting to have a combo box that will allow me to look my through table, allow me to select an already created object or create another.

[djdates]

@giorgio89789 Great point! When you type in a director that doesn't exist, you get a message saying "The Text you entered isn't an item on the list". However, Access also triggers the NotInList event, and we can write some code that will automatically insert the director into our table. However, because we are typing in the name as "Lastname, Firstname", we will need to do some string manipulation. Google "NotInList" or check back in a week, and I'll walk through the needed code.

[bmarshall786]

Hi, this maybe a really stupid question but i am having trouble following the video. I have got to the point with my form where I have created the form and the query. But my Director ID hasn't actually changed to names, also i'm not pulling back two columns. What am I doing wrong?

[djdates]

@bmarshall786 You may have missed a step. At about 5:15, we set column count to 2 (which tells the combobox to show two columns) and column widths to 0" (which hides the first column, so only the second column, the names, are shown.) Hope this helps.

[pedrohiramlive]

Hey your vidio have help me alot ... I just have one questions... in my access 2007 if I try to change the combo box to show data instead of the ID, when I get to the DATA tap I do not get a ROW SOURCE... can you help???

[djdates]

@pedrohiramlive You may not have a Combo Box yet. Right click on your field, click on Change To, and then select Combo Box. Hope this helps.

[agapitoflores001]

i am really looking for this kind of video to help me improve my work. Great help!

[broken00heart00]

i'm having problem with creating the search button. Can anyone help me please?

[shoexy]

Excellent video !

[slathered]

I realize that one can pause and start the video at will, but why do you have to talk and click at such a fast pace??

[Josephdoan]

great tutorial ! i was able to adapt it to my project.

just a question: is there any way that by selecting the title from the drop list in the form, all relevant info (MPAA_rating, release_year ...) will appear automatically for that record ?

Or navigating record one by one at the bottom of the form (i.e. record 1 of ...) is the only way ?

Cheers,

[1mustangsally]

Speaking slower would help. All I hear is blah, blah, blah. It's hard to follow.