troubleshooting Question

Trying to populate field on a form based on selection from another combobox

Avatar of SteveL13
SteveL13Flag for United States of America asked on
Microsoft Access
3 Comments2 Solutions90 ViewsLast Modified:
I am trying to make a field on a form named txtWORKING_INTEREST fill with a DMax from a table.  The code I'm trying is:

Me.txtWORKING_INTEREST = DMax("[WORKING_INTEREST]", "tblPropertyInterests", "[PROPNUM] = '" & Forms!frmRecordsHeader!txtPROPNUM & "'")

And the table, tblPropertyInterests" looks like this for txtPROPNUM:

Table Example
But the after update event keeps filling the field txtWORKING_INTEREST  with 9.350474  (which is a text field as is txtPROPNUM on the form).

What have I missed?
Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros