General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Mary-Ann.
>Have two variables that a grid uses to display records with a view.
>Have a combo box that has three columns, ProductName, ItemNumber and RevisionNumber, which is where the two vars come from. I want the second and third column values:
>Var1=thisform.combo1.list(thisform.combo1.listindex,2)
>Var2=thisform.combo1.list(thisform.combo1.listindex,3)
>I don't think I understand the list/listindex because the refresh that calls the requery is not getting the two vars, or so it seems.
I notice that columns 2 and 3 of your combo have the word 'Number' in them. Does this mean that they are actually of numeric data type and that you need a number to requery your view? If so, you need:
Var1=VAL(thisform.combo1.list(thisform.combo1.listindex,2))
because the all the items in the list are stored in character format.
Marcia
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