Dlookup controls will not refreash

[gwill23]

I have several controls on my form that use Dlookup to get information from another table some are based on the value of a field on the form and others are just looking up the current profit margin from a table I have defined those type of variables in. I then use those amounts to calculate totals and such.

When I create a new record is works perfect..execpt for those in the subform. However, if I change the field the information is based on I need it to lookup the new values. Is there a way to make them update?

If I close the form and reopen it the values of course look up to the current ones.

I do not save these values as they are subject to change and I don't want them to all change at once.

 

[gwill23]

Sorry for the newbie post.

I am just starting to do this again after many years.

Anyway here is how I did it.

Private Sub Customer_Type_Change()
On Error GoTo Err_Customer_Type_Change


DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

Exit_Customer_Type_Change:
Exit Sub

Err_Customer_Type_Change:
MsgBox Err.Description
Resume Exit_Customer_Type_Change
End Sub

I really just copied the refreash button it makes for me automatically.