It is a long time since I played around with Access and just getting back into it after a layoff of about 10 years so please forgive the question.
I have a main table that has a field in it called Family as a long integer. I have a second table called family_group with just one field in it an autonumber.
I have a form that has the main table fields in it and a combo box to select the family group. This works fine BUT I want to put a button on the form that creates a new record in the family_group table and then displays that value in the combo box. I am certain that I did this type of thing in the past but can't remember how.
Any tips most welcome.