.RowSourceType = 6 && Fields .RowSource = "TableName.Name,Address" && quotes not required in property sheet && and alias should only be specified for the first field. .ColumnCount = 2Then in the valid event all you need to add is:
ThisForm.Text1.Value = TableName.Name ThisForm.Text2.Value = TableName.Address