CODEWITHSUNDEEP
ms-accessms-access-2007vba
Muhnamana
Muhnamana

Reputation: 1044

Filtering A Lookup Field Based On Another Field

I have a lookup field in my table based on another table. I'm having trouble filtering those values based on another field that is entered prior to the field.

Is it possible to filter a lookup field based on another field?

EDIT

Let me try and clarify my original question, sorry about that. Ok, so I have a table1 that has the following fields: ID, Name, Logo.

If a user enters a specific name in the Name field, when they click on the Logo field, it'll only display those values associated that are similar to the name entered. Does that make any sense? If it does make sense, would there be an easier suggesion on accomplishing this task?

Upvotes: 1

Views: 12709

Answers (3)

Rollin Shultz
Rollin Shultz

Reputation: 13

It sounds like he is having the same issue as me. I also wanted to filter a field in a table for data entry on another field's input and my conclusion is "it is time I stopped entering data manually in tables and begin to create Data entry forms. I was putting this task off until later, but if I don't do it now, I might make worse trouble for myself later. Btw, what an old thread.

Upvotes: 0

Linger
Linger

Reputation: 15068

Here is an example of how to handle filtering a combo box based on the value selected in another combo box:

I have the following form:

enter image description here

The combo boxes are named cboIntPN and cboManPN.

The Row Source for cboIntPN is set to: SELECT uniq_key, part_no, revision FROM inventor. The Row Source for cboManPN isn't set to anything.

When the user selects a value for Internal PN the following AfterUpdate Event is triggered:

Private Sub cboInternalPN_AfterUpdate()
   [cboManPN].RowSourceType = "Table/Query"
   [cboManPN].RowSource = "SELECT uniqmfgrhd, mfgr_pt_no FROM invtmfhd " & _
                          "WHERE uniq_key = '" & cboIntPN.value & "'"
End Sub

Upvotes: 3

Johnny Bones
Johnny Bones

Reputation: 8414

If you're talking about inside a table, the answer is "No". You can create cascading combo boxes on a form, but you can't base a lookup value in a field of a table off of a different field in that table (or the field in any other table).

Upvotes: 3

Related Questions