Search results

Maybe this will help some, I've attached a sample report. Your file looks much cleaner, structure wise, than what I have currently, but I don't see how to start a new case. The end report will show up to 5 cases for the audit. To make table structure changes I would have to redo the report...

I hadn't thought of macro's, I'll give it a try. I agree, that 5 subforms as it is now is rather inelagant. If I can get your suggestion to work I won't even need subforms, that would be great.

Ok, I'll run through an example case study. I buy 100 cases of chicken from The Chicken Farm. Each case has say, 7 chickens, 8 if they're small. For a given case I would want to track all the information I need related to that particular order. For the audit, lets say the chickens weigh the...

Awesome Mike375, was just working on that as you posted. See the above... help.mdb

[edit] uploaded mdb rather than the screen shot. Thanks

Thanks. A case of meat has several retail packages each labeled with a weight. The case also is labeled with a weight. I audit random cases to ensure all these weights are accurate. My info table would have vender, date, purchase order, product description, and 5 fields for case labels. The...

I have a table for idenifying fields, with one subtable for data fields. The data table has 5 fields with multiple records for each record in the info table. I need the data entry to run so that for field one, when you hit enter instead of going to the next field it goes to the next record in...