Combo Box

[kenrav]

I have a combo box on one of my forms. Currently, the box's Row Source Type
is tied to a table.

I'd now like the contents of the combo box to vary depending on the user.
In other words, User A might have 15 selections whereas User B has 30.

The way I'm thinking about approaching this is to tie the box's Row Source
Type to a Parameter Query (using 'User' as my criteria.)

Is this the way to go or is there a better way? Thanks.

 

[Jeanette Cunningham]

Hi kenrav,
yes, you could do that if your users log in to use the app.
Of course you then need to cater for the scenario where user A with 15
selections edits something that only appears in the combo for user B and
then wants to change it back. They will get a message that they must choose
an item from the list - and the term previously chosen by user b will not be
there for them to choose.

Perhaps easier if user A can only see the records entered by user A and user
B can see all the records in the form.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia