Hi, I'm quite new to Access and I'm having trouble with a form I'm working on. It's probably a straightforward solution, but I haven't figured it out yet.
For a bit of background, I'm collecting a large number of DNA samples from a variety of fishing locations. I have two main tables, one describes each fishing location, and one keeps track of all the DNA samples from each location (one location to many samples).
I would like a form to use when I'm entering new samples that shows all the existing samples from a specific location, but because there are a number of locations I would like to use cascading combo boxes to help me find the correct location. I've gotten this far, I can use cascading combo boxes to find the correct Location ID, but I'm stuck at how to proceed.
I would like a form that shows the important Location information but does not update the Location table (if I need to edit location information, I'd use a different form) so it isn't really a subform that I need. Next, once I have all the samples from that location, I want to be able to fill in sample information for new samples, but that automatically assigns the correct Location ID to the sample.
I really appreciate any help, thanks for your patience with a beginner!
For a bit of background, I'm collecting a large number of DNA samples from a variety of fishing locations. I have two main tables, one describes each fishing location, and one keeps track of all the DNA samples from each location (one location to many samples).
I would like a form to use when I'm entering new samples that shows all the existing samples from a specific location, but because there are a number of locations I would like to use cascading combo boxes to help me find the correct location. I've gotten this far, I can use cascading combo boxes to find the correct Location ID, but I'm stuck at how to proceed.
I would like a form that shows the important Location information but does not update the Location table (if I need to edit location information, I'd use a different form) so it isn't really a subform that I need. Next, once I have all the samples from that location, I want to be able to fill in sample information for new samples, but that automatically assigns the correct Location ID to the sample.
I really appreciate any help, thanks for your patience with a beginner!
