Donkeygirl
Technical User
I am working on an application with the following. Two tables, in a one to many, one indexed, are in a query. The query is set up in fields in a form. I am trying to make this work in two steps. The form is meant for a user to enter in an address as a lookup (no adds, edits, or deletes). Once entered in to the appropriate fields, either by running a query, macro, or using vb code, information about the address would be brought up.
In the first step, if the user does not have the entire address, they would enter what they have, and possible addresses would be dumped into a list box, or maybe something better. (Its what I have looked at as the likely avenue, but there may be an easier way.)
In the second step, once the user has filled in the entire address, a query/mcr, or vba would be used to call up the other half of the record.
The outlying problems are that the street number is split in two fields, beginning number and end number( <= and >= ). Also, the "one" primary key is in the second half of info to be filled in (it is what we are looking for...along with its description)
Any help with any of this would be greatly appreciated thanks
In the first step, if the user does not have the entire address, they would enter what they have, and possible addresses would be dumped into a list box, or maybe something better. (Its what I have looked at as the likely avenue, but there may be an easier way.)
In the second step, once the user has filled in the entire address, a query/mcr, or vba would be used to call up the other half of the record.
The outlying problems are that the street number is split in two fields, beginning number and end number( <= and >= ). Also, the "one" primary key is in the second half of info to be filled in (it is what we are looking for...along with its description)
Any help with any of this would be greatly appreciated thanks