>Todd,
>
>Do you need this view for other purposes or only
>for the source of your drop-down comboxbox?
>
>If the latter, I suggest you do it this way:
>
>Set your drop-down combo RowSourceType to SQL Statement (3)
>and the put your SQL Statement as the RowSource. This would be
>something like this:
>
>RowSource=select * from lookup_table where set_name=thisform.MyValue
>
>You need to define a new property for the form called MyValue where
>your store the information for your query parameter.
>
>HTH
>
>Pascal
Also, be sure that the property is of the correct data type and not thee default of .F. which might cause an error if the query is expecting char/numeri.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement