I am working on the following application- A form from a query. Query is of two tables and in a one to many relationship. I am try to make to form useable for the following. First is to be able to look up records. I have fields in for street number, street, city, and zip. I want this to be a look up form only. No adds or edits. I can't even get the form to work for this type of entry. The proccess of the working application would have two possible avenues. One if the user does not have the full address, they would fill in the fields (or part of fields) for what they know. Upon command, a list box (or maybe a subform?) would fill in with possible addresses from the query's records. Once the user fills in the address the point is for them to be able to call up the other have of the record. Information about that address. Here are the problems. The primary key is one of the fields being looked for, it is not known to the user. The other glitch is that the street number is in two fields in the query, beginning number on the street, and end number on the street.
Anyone who can help, I'd love to hear from you!
Thanks
Anyone who can help, I'd love to hear from you!
Thanks
