Search results

Thanks Bob. Thats tidied the code up but still have the problem. The text box changes number. But my if statements that change the label visible or not visible doesn't update itself I'll try the bookmark method later, but Iwant to understand why the refresh / recalc method doesn't work. In...

Have you tried using the default value property that references the ID number from the previous form?

I'm looking for some help regarding refresh. I have a main form. I open a second form and add records. I want a label on the main to indicate whether I have records in the 2nd form/ table relating to the displayed record or not and change if I remove all the records or add a new record...

There are trigger dates for each one. These are determined by the start of the contract and the length of the contract (all field in the original contract table). I'd prefer them prepopulated as waiting to be received so I can log various details of the claim as they come in. I should be able...

The one side is contract. The many side are claims. Each contract will have 3 claims. Is there a better structure to reflect this ?

Hi, I've got a working database with pretty good structure etc. one thing I can't figure out is how I would go about creating 3 prepopulated records on a many side of a relationship on entering a new record in the one side of the relationship. Any pointers?