11-18-04, 16:53 #1Registered User
- Join Date
- Nov 2004
Unanswered: Filling a table with patrol based on a set range
I’ve got a table that has road names and mile posts in it. A second table has a list of patrols with the roads, beginning mile post and ending mile post that they are responsible for. I want to create a third table that will list all the roads in table one with the patrol name that fits between the beginning and ending mile post. Some of the roads in table one will not fall into the criteria in table two so it should list in table three that ‘no patrol’.
I made a query and only get the roads that fall into the ranges of patrolled roads in table two. Or get multiple entries of the roads in table one; one listing the correct patrol and the remaining listing ‘no patrol’.
Perhaps there is another way of performing this.
11-18-04, 19:40 #2Registered User
- Join Date
- Sep 2003
- The extremely Royal borough of Kensington, London
Private Sub control_AfterUpdate
comboBox.rowsource = "..."
End SubBessie Braddock: Winston, you are drunk!
Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.