Updating fields in access

Posted by / 23-May-2018 03:10

Updating fields in access

You'll probably want to apply what you learn to the Premium fields After Update event.

Therefore, I'll need the ability to change the amount in the Brokerage field from time to time - with a Query, that won't be possible. I am a newbie so if you can provide me with step-by-step instructions, it will be most appreciated. Haas: Here is some code I've used in one of my forms, modified (I think) to your needs.

Whatever amount is in the Premium field is multiplied by 10% in the Brokerage field.

If I change the amount in the Premium field, the Brokerage amount should change accordingly as well.

Taking care of the common cases is good enough for me. Sub Update All Fields In(doc As Document) '' Update tables. Update Next toc Dim tof As Table Of Figures For Each tof In doc.

See Adrian thread on this is you're still confused.

Quotes (') and Double-Quotes (") - Where and When to use them Mary Assuming Owner is a text field you will need the single quotes.

Hi all, I was wondering if any of you guys can help me out with this: I have two fields on a form: one field is Premium and the other is Brokerage.

Ron Hi all, I was wondering if any of you guys can help me out with this: I have two fields on a form: one field is Premium and the other is Brokerage.

Therefore, I'll need the ability to change the amount in the Brokerage field from time to time - with a Query, that won't be possible. I am a newbie so if you can provide me with step-by-step instructions, it will be most appreciated. Take a look in the help files for a topic called or similar to "Set the value of a control based on the value of another control by using Visual Basic".

updating fields in access-74updating fields in access-18updating fields in access-46