I know it's not advised but... How do I get field 2 to auto-populate information based on field 1

[lccrews]

Field 1 on my table is a combo box with 2 pieces of information. I'd like field 2 to auto-populate with column 2 of field 1. I don't want to use a query or a form. Is this possible?

[pbaldy]

In a table? I doubt it. You have much more control in a form:

BaldyWeb - Autofill

Most of us never let users have direct access to tables or queries.

[lccrews]

Well I have a form that requires user input and I need to store that information in a table. Problem is, one piece of information is redundant. I don't know how to have the user input what they want, use a combo box and auto populate another field and have all that information store to a table.

[pbaldy]

Well, the link shows a way to just display the second field without storing it, which is normally all you need. If you need to store it, there's a method shown for that as well.

[BRASILO]

Field 1 on my table is a combo box with 2 pieces of information. I'd like field 2 to auto-populate with column 2 of field 1. I don't want to use a query or a form. Is this possible?

There is two ways you could try this.

On the field that you are filling/choosing the info for; Under the OnChange procedure you can add a code to populate the info to the other fields. The other one is after update. same code. Below is a little code I use to update two fields from a drop down menu.

Private Sub empNAME_Change()
    Me.fromBOX = empNAME.Column(1)
    Me.empEMAIL = empNAME.Column(2)
End Sub