Problem with Requery

[labbadabba]

I'm performing a DSum on a subquery that adds up percentages for different customer types. Whenever the percentage is changed the DSum needs to reflect that so the person doing the data entry knows that all the percentages add up to 100.0%. I set up a requery macro for this function. This worked fine until I started doing sample entries. It wouldn't let me put in a decimal point. So I went into Visual Basic but I think my code is bad:

Private Sub Mix_Percentage_Change()

Queries!QRY_Customer_Mix_Form_UserSubForm![Customer_Mix].Requery

End Sub

Help??

 

[Rod D]

Are you sure it is the query that is the problem?
The data type of the field is more likely to be "at fault". Check the definition for this field, you will probably find that it is set to "Long Integer" which cannot hold fractions.

Lookup help on "field size property" for the options here.
HTH
Rod