Search results for query: *

Something like- if recordcount(subform) > 4 then mainform.allowadditions = false This will make the last line in the datasheet (the one with the *) go away.

I have a main form that has a combo box for choosing customer, and two sub forms (both sub of the main form). sub1 is a continuous form, no additions, of existing orders for that customer. sub2 is the details of each order (it shows which budgets each order comes out of). sub1 has an 'on...

pfff. Never mind. I removed subform2, then put it back without resetting the name.

Hi- I have a main form that has a control for selecting a customer. Once a customer is selected subform1 becomes visible and filters to show that customers orders. Now, on subform1, on the OnCurrent event I want subform2 to become visible in mainform and show the details for that order. I have...

Thank you both, I'll carry on with this model. Duane - changing the name does make it easier to understand, thanks for the suggestion.

I've been tasked with fixing re-designing an access tool for tracking purchases that are allocated among different locations. I have: BUDGETS office (PK) region budgetAmount (for the year) PURCHASES purchID (PK) office (FK) date po_number description DIRTRIBUTION distID (PK) purchID (FK)...