Combo Box

  • Thread starter Thread starter kenrav
  • Start date Start date
K

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.
 
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
 
Back
Top