Unbound controls changing to #Error after refresh, & not showing value unless clicked

[Janzi]

I have a form that summarizes a lot of data about Contract Items.

For now, it summarizes the Total Scope, summing all Increases and Decreases in the Scope of the work, i.e. initially agreed on 100 units, later decreased by 20 units (to 80), later increased by 12 (to 92), displays '92'. I get this value through a totals query which simply takes the ItemCode and sums all the values in the table for that ItemID, in this case 100,-20,12 = 92

This value is displayed on the form when the ItemCode is selected from a Combo box. (cboItemCode)

It also summarizes our estimated quantities for the same item. Initial estimate on Jan 1 was 50, revised estimate on Feb 1 was 60, I have a query which picks the latest estimate and returns the value, in this case, '60'. This is also displayed on the form.

so my form has at the top a combo box to Select the ItemCode for which we want to view the summary.

Then there are two boxes - one for Current Scope, which should display 92, and one for Last Estimate, which is 60

I've managed to get these values to show up, but there are some problems:


1. The current scope doesnt update automatically when different ItemCode is selected in the combo box. So I added an 'afterUpdate'- Requery to the combo box cboItemID.
However if I click F5 to refresh the form again, the box for Current Scope changes to #Error

2. The Last Estimate box is blank, until I click in it, at which point it suddenly displays the value 60. Again, if I hit F5, the value disappears.

This wonky behaviour is driving me nuts!

I would appreciate any help!

Thank you to the entire Access community!

Janzi

[Missinglinq]

I've been reading this post for three days now and still have no idea what you're trying to convey. The fact that 20+ other members have read it and not responded probably means that they couldn't understand it either. Don't feel bad, it's often hard to convey what you're tyringt o do to others who are not in your particular industry.

Primarily, I don't understand why you're refreshing your Form. A Refresh is done in a Multi-User Environment so that UserA can see changes that have been made to existing Records by UserB, UserC, etc. To see New Records entered by other users, or to not see Records that other users have Deleted, you'd have to do a Requery.

If you're trying to make Calculated Fields reflect changes that have been made, which is kind of the feeling I'm getting about your situation, here, you need to execute a Me.Recalc Command.

Linq ;0)>