Essentially, I'm looking for a way to pick data out of ComboBox1 from a select statement and upon that selection, autofill Combobox2 with data from the same select
So, if box1 is LastName I'd want FirstName to come up but I'm not 100% on how to get them to talk to each other. Any help would be appreciated.