Broken cbo when split - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Broken cbo when split

Nikki Wilcox

2 years ago

I have a combo box (staffiD) that populates 4 fields (First, Last, Email, and Program) in my form. when I split the database the combo box only populates the Email and Program fields. How do I get it back to populating the First and Last fields?

	Sami Shamma @Reply 2 years ago
How are you doing the population?

	Nikki Wilcox OP @Reply 2 years ago
with this code: Me.txtStaffFirst.Value = Me.cboStaffID.Column(1) Me.txtStaffLast.Value = Me.cboStaffID.Column(2) Me.txtStaffEmail.Value = Me.cboStaffID.Column(3) Me.txtStaffProgram.Value = Me.cboStaffID.Column(4)

	Sami Shamma @Reply 2 years ago
You know that Combo.Column(0) is the first column. could that be the problem?

	Nikki Wilcox OP @Reply 2 years ago
it works when I'm building the form, so I don't think so, and it only breaks the first and last name process when I split the database. After splitting the Email and Program fields continue to populate just not the first and last name fields.

	Kevin Robertson @Reply 2 years ago
Your code can be simplified: `txtStaffFirst = cboStaffID.Column(1) txtStaffLast = cboStaffID.Column(2) txtStaffEmail = cboStaffID.Column(3) txtStaffProgram = cboStaffID.Column(4)` As to your problem we will need more information (screenshots, Row Source of your Combo Box, Property Sheet). Any relevant information to help us troubleshoot your problem.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View