Não mostrar determinados usuários num Formulário

[ssporch]

Prezados,

No arquivo anexo, mostro um Formulário onde preciso que, quando algum usuário clicar no campo RESPONSAVEL, não sejam exibidos os Responsáveis ROGER ARIAS e MIRNA VALVERDE.

Como fazer?

Um abraço,

Sérgio Sporch

[orange]

Translated from Portuguese via Google translate

In the attached file, I show a Form where I need that, when any user clicks the RESPONSIBLE field, the Responsibles ROGER ARIAS and MIRNA VALVERDE are not displayed.

How to make?

What is the rowsource of the Responsibles combo?
(From Google translate ---Qual é o rowsource da combinação de Responsáveis?)

If the rowsource is 1)a query, or 2)a value list --

1- add criteria to ignore these
2 -remove them from the value list

[ssporch]

Thanks for your prompt answer!

But my doubt is how to do this.

If query, how to do this?

If value list, how do to this?

Please could you send me some examples?

Regards,

Sergio Sporch

[orange]

Post a copy of your database in zip format.

[ssporch]

My friend,

I sent attached the Database!

Thank you for your efforts!

Regards,

Sérgio Sporch

[Shadow9449]

E ai, Sergio. Bemvindo. Posso ajudar em ingles. Se nao entender pode perguntar em portugues.

In the query for the Row Source of the field "RESPONSAVEL", go to the CDO_RESPONSAVEL field and add the criteria "<>2 And <>4". That will exclude the names with those associated IDs.

[orange]

Or add a where clause to the existing rowsource to make it more generic

where Activo = True

[Shadow9449]

Or add a where clause to the existing rowsource to make it more generic

where Activo = True

Good call! I didn't delve into the tables enough to see why those were being excluded - I just posted the direct solution but yours actually addresses what Sergio is after.

[ssporch]

Good call! I didn't delve into the tables enough to see why those were being excluded - I just posted the direct solution but yours actually addresses what Sergio is after.

I didn´t received you direct post.

Could you send to my email (sergio.sporch@gmail.com)?

Thanks and regards!

[Shadow9449]

I didn´t received you direct post.

Could you send to my email (sergio.sporch@gmail.com)?

Thanks and regards!

Desculpe, mas não quero. Voce ainda tem uma duvida?