D
Dave
I'm trying to create a form that will allow me to type in a street name, and
after that select the civic number range that applies. Each street should
have several civic number ranges so I want to select it from a list. After I
select the appropriate civic number range, I want a unique ID attached to
that range to appear in a separate field.
What I've done is create a 'Enter Street Name' query, and changed the civic
number field to a combo box taken from the query. The problem is the civic
number range doesn't change after I enter a different street name.
Any help is appreciated,
Dave
after that select the civic number range that applies. Each street should
have several civic number ranges so I want to select it from a list. After I
select the appropriate civic number range, I want a unique ID attached to
that range to appear in a separate field.
What I've done is create a 'Enter Street Name' query, and changed the civic
number field to a combo box taken from the query. The problem is the civic
number range doesn't change after I enter a different street name.
Any help is appreciated,
Dave