Some basic questions about Forms. Not urgent. (1 Viewer)

[SachAccess]

Hi,
I am trying to learn MS Access Form structure, properties etc.
Am thinking about posting the basic questions I have. Am not sure if it violates Forum rules. Apologies if it is not allowed.
If permitted I will post all my questions in this original post only.

This MS Access file is not created by me. While posting, I might edit few field names. Uploading is not allowed either.
I have many forms in the MS Access file I have for learning purpose.
I open one form in Form view.
It has several combo box items.
If I go to form view and select any of the combo box I get an option for drop down.
In the drop down there is a list of names which I can select.

Post this, I moved to Layout view on the same form.
I right clicked on one of the combo box, selected properties.
Then I moved to the Data option on the properties.
There I can see DummyName1 as Control source.
There is also a drop down at Control source.
If I select the drop down I get two more values DummyName2 and DummyName3
There are 3 dots next to the drop down, if clicked, takes me to Expression builder.
In the Row source, I can see an SQL query.
Row Source Type is Table/Query.

Can anyone please help me understand how does this works. Not urgent for me. Please help only if you get time. Thanks.
I have few more questions about these options. If allowed will post further.

 

[Gasman]

You really would be better off buying a book and reading it from beginning to end, or relevant chapters.
I was given https://www.ebay.com/sch/i.html?_fr...0.l1313&_nkw=access+2007+for+dummies&_sacat=0 as I was using Access 2007

 

[MajP]

Not sure exactly what the question is.
A combobox can have three types of rowsources (value list, Table / Query, field list)

1. In a value list you type in the values seperated by semicolons
"Red"; "Blue", "Green"
If it is a value list there is another property
Allow Value List Edits
If this is yes, you can add to the pull down choices on the fly.

2. If the row source type is Table/Query you can define which table or query (or a sql string). The three dots will allow you to build a query for the combo instead of picking an existing one.

You then define which column to pick a value from and you select which columns to show and hide.
It is common to pick a key column to pick from, but hide it and show a descriptive column. Important properties
Bound Column: which column holds the value to store
Column Count: how many columns to return
Column Widths: 0;1;3 (this example says hide the first column, make the second 1 inch, make the third 3)

3. Field list you will never use so do not worry about it.

 

[Gasman]

With a picture being worth a thousand words.

https://www.youtube.com/results?search_query=access+forms+tutorial

 

[MajP]

This is a little more focused on the combobox. Pretty good.

MS Access 2010: Row Source Type for combo box

This MSAccess tutorial explains how to set up the type of Row Source for the combo box in Access 2010 (with screenshots and step-by-step instructions). When configuring the Row Source Type property in Access 2010, there are 3 values to choose from.

www.techonthenet.com

 

[SachAccess]

You really would be better off buying a book and reading it from beginning to end, or relevant chapters.
I was given https://www.ebay.com/sch/i.html?_fr...0.l1313&_nkw=access+2007+for+dummies&_sacat=0 as I was using Access 2007

Thanks for the help. Will surely do.

 

[SachAccess]

This is a little more focused on the combobox. Pretty good.

MS Access 2010: Row Source Type for combo box

This MSAccess tutorial explains how to set up the type of Row Source for the combo box in Access 2010 (with screenshots and step-by-step instructions). When configuring the Row Source Type property in Access 2010, there are 3 values to choose from.

www.techonthenet.com

Thanks for the help. Have a nice day ahead.