Question Dlookup or query for combobox?

[alekkz]

hi everyone,

I have an issue I would like to get some help with.

I currently have a table with the following fields (loginID,Level) there is 10 entries. the "Level" field only has 3 possibilities either (Level 1, Level 2, or Level 3)

ideally I would like to have a combobox display only "loginIDs" that correspond to "Level 2"

am not sure if this is possible with dlookup or if would be better with a query? I really don't know much about using queries so I want to avoid them as much as possible.

thanks

 

[pbaldy]

A query with a criteria would be the normal solution.

 

[alekkz]

can you help me out with it? I have tried to create queries before (not for this) and I have no clue on where to begin

thanks

 

[plog]

I really don't know much about using queries so I want to avoid them as much as possible.

That's like telling a priest you enjoyed his mass, but wish it was lighter on all that God and Bible mumbo jumbo. Queries are the reason you should be using Access, take those away and you might as well be in Excel. I'd read up on them (http://www.w3schools.com/sql/).

As for your issue, you would need to use a query as the Row Source of your drop down (Properties->Data->Row Source)