Inserting fields from a record when a selection is made in a ComboBox

[Sadsfan]

I am a beginner using Access. And I am creating a database to log telephone calls. I have two tables, one called 'Families' and another one called 'Call Records'


'Families' has the following fields:

• 'Family'
• 'Children
• 'Status Code 1'
• 'Status Code 2'
• 'Status Code 3'

I have created a form in 'Call Records', I have added a ComboBox that lists the family names from the 'family' field in the 'Families' table.
What I would like is, that, when they select a name, it populates other text boxes with the other fields for that record from the 'families' table. Is it possible to do that?
I am using Access 2016.

[Bob Fitz]

Include all the required fields in the Row Source property of the combo box using a predefined query or an SQL Select statement.

Adjust the Column Count property to include all the required fields and the Column Widths properties for each column.

Set the Control Source property of a text box to = NameOfComboBox.Column(1)
The figure in brackets refers to which column you want the data from. First column is (0), second is (1) etc.

[Sadsfan]

Thanks Bob, I will have a try at that, I'm a beginner, so some of that sounds complex to me, but I will have a go at figuring it out!

[Bob Fitz]

Thanks Bob, I will have a try at that, I'm a beginner, so some of that sounds complex to me, but I will have a go at figuring it out!

Good Luck
Let us know if you need any further help.

[Sadsfan]

Thanks Bob, the first part was fairly simple, I created the query and then added that to the row source property.

When I go to the property of a text box I have typed in what you said, and it changes it to this:

and then nothing appears in the text box when I select a family name from the combo box.

Thanks

[Bob Fitz]

Did you:
Adjust the Column Count property to include all the required fields and the Column Widths properties for each column.

I've attached a very basic example for you to look at:

[Sadsfan]

Thanks Bob, that worked a treat. Last question... How do I get the form to write that information to my call record table? By that I mean the information that has been copied into the text boxes.

Maybe I should be a bit clearer on this.
I want the form for call record table to get some of the information from the families table (so people don't have to type out all of the information, e.g. surname, forename etc)

The form will have additional boxes to fill in e.g. date called, message left, conversation had

And then all this information on the form to be added to the call record table

[Bob Fitz]

Sadsfan

How do I get the form to write that information to my call record table? By that I mean the information that has been copied into the text boxes.

You don't.
In a relational database you don't duplicate data from one table to another. You have relationships between tables. Mostly these are one to many. For example: One customer has many orders. Each order has many items.
I would strongly advise you to read a little on the subject of relational database design.

[Sadsfan]

Thanks Bob, I will do some reading. Thanks for your time.