>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only