Combo Fields - Microsoft Access Forum - Computer Learning Zone


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Combo Fields

William Kennedy

3 years ago

I have a table of Office Titles that have associated ranking field that is used to select groups of Offices in different reports. The Office names are in a table along with the ranking number, it is used as a combo control in other forms and reports. Ive been trying to find the video that showed how to use a combo control to not only display both fields in a form but also to store the associated ranking back into a table. Can someone point me to the video?

	Kevin Robertson @Reply 3 years ago
This one? Relational Combo

	William Kennedy OP @Reply 3 years ago
Thanks Kevin

	William Kennedy OP @Reply 3 years ago
Hello Kevin, Just finished Reviewing Relational Combo. Not exactly what i was looking for. Example: I have a Table used as source for a Combo Box control. The table has two fields. [MemberType] and [Dues]. I use the combo box to bring in member type into my form. I would also like to automatically bring in [Dues] into a separate table field. Sorry for any confusion.

	Kevin Robertson @Reply 3 years ago
How about a DLookup in the After Update event of the Combo Box. Also: AfterUpdate & DLookup

	William Kennedy OP @Reply 3 years ago
Thanks Kevin I will try that.

	William Kennedy OP @Reply 3 years ago
That's the one. Thanks Kevin

	Kevin Robertson @Reply 3 years ago
You're welcome.

	William Kennedy OP @Reply 3 years ago
I've been working on this a couple days. Still missing something. Tried a different two fields. Still not working. Attached I have the Snip & Sketch JPG for the tables and Forms I'm working with.

	William Kennedy OP @Reply 3 years ago

	William Kennedy OP @Reply 3 years ago

	William Kennedy OP @Reply 3 years ago

	William Kennedy OP @Reply 3 years ago

	Kevin Robertson @Reply 3 years ago
In the Rank Combo Box, is the first Column the ID? If Rank is in the second Column, try this: `Honor = NZ(DLookup("Honor","Mem_125_Rank_T", "Rank=""" & Rank.Column(1) & """"), "")`

	William Kennedy OP @Reply 3 years ago
Sorry Kevin. Still does not work. I really do not understand the DLookup and why it is not working.

	William Kennedy OP @Reply 3 years ago

	William Kennedy OP @Reply 3 years ago

	William Kennedy OP @Reply 3 years ago

	William Kennedy OP @Reply 3 years ago

	William Kennedy OP @Reply 3 years ago

	William Kennedy OP @Reply 3 years ago

	William Kennedy OP @Reply 3 years ago

	Kevin Robertson @Reply 3 years ago
Did you name your Combo Box? Examples: RankCombo cboRank `ComboBoxName.Column(1)`

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

Next Unseen

New Feature: Comment Live View