I am attempting to use the requery action in a macro to refresh a forum.
The requery is (attempting to)update an individual control which is a combo box in a forum. That control is coming from a Field in a table named "product line". When i change the product line in the forum i would like a different combo box named "type" to requery, and thus only allow me to select a type that is in that product line.
Do i use the 'after update' event? in the requery macro, what do i enter as my control?
I don't know SQL language.
The requery is (attempting to)update an individual control which is a combo box in a forum. That control is coming from a Field in a table named "product line". When i change the product line in the forum i would like a different combo box named "type" to requery, and thus only allow me to select a type that is in that product line.
Do i use the 'after update' event? in the requery macro, what do i enter as my control?
I don't know SQL language.