Its been a while I was giving up on Access but I am at it again because its too handy so when you reply keep in mind I am an Access idiot lol.
First. I have a zip code table and in my form I have City State and Zip. I want to enter the zip code and the zip code tell me the township or townships it belongs to. If there is only one I would like it to auto populate the city field.
1 zip code could be part of more than one township. So I would enter 19526 and I would get something that says do you want Windsor or Hamburg. with out showing the entire list of options that are not part of that zip code. then click on the right one and populate the city field.
Second in the database I have an entry form and have an update form. I don't know if I need it I might just need a search box for the OLN field to get the form to update it.. Ur advise would be appreciated.
If the search to the form would be the way to go, how do I/we set that up and can the OLN be the main field to search.. Typing this out I think that might be the best way to go.
Right know I also have a ID key cause access said I need one but the OLN is a unique number and I wonder could that be the ID Key?
Third. I need to do a search that says anything with no received date to return all those records so I can update them or take further action.. Again some advise how to do this would be great. and from that list would create a table I guess so I could send a second letter and envelope.
So I know this is a lot but I learned from trying to ask question in the past that one at a time was not the way to go because I get yelled about all the different things going on so trying to avoid that this time.. Please help
I attached the database it has dummy info in it.. The Trooper Assigned list pulls from a master database that holds all employees in it so not sure it will work for you but works good for me.