Search results

I finally figured out what was wrong and thought I would post in case this is happening for others. It was the security warning (active content) at the top of the window. I was just ignoring it. Once I clicked on Allow, it worked in the original format - Me.fieldname =...

I have the same exact issue as tmort. Using Access 2010. When I open the subform by itself, the combo updates the fields correctly. But when I run it as a subform, it doesn't update the fields. There is no error, it just doesn't update. This is the syntax that works on the form (when not...

Still no luck. Giving up for now. Thanks anyway!

Patient ID is alphanumeric. That may be why it doesn't work. Will try with single quotes.

If I use the build wizard, it comes out like this: =DLookUp([tblAccount]![PrimaryInsurance],[tblPatientDatabase]![PrimaryInsurance],[tblAccount]![PrimaryInsurance]=[tblPatientDatabase]![PrimaryInsurance]) Again, I don't know what I need for criteria - still shows as #Name?

=DLookup ("[PrimaryInsurance]" , "tblPatientDatabase" , "PatientID = PatientID") returns nothing =DLookup ("[PrimaryInsurance]" , "tblPatientDatabase" , "tblAccount.PatientID = tblPatientDatabase.PatientID") returns #Name? =DLookup ("[PrimaryInsurance]" , "tblPatientDatabase" ...

Okay, so I know what to put in the "field" and "domain" but what would I use for criteria? I want to populate PrimaryInsurance in tblAccount from the same field in tblPatientDatabase. I would guess it is patientID, but I can't seem to get the syntax right. =DLookup ("[PrimaryInsurance]" ...

I have a form (frmAddAccount) with a subform (frmAccountSub). In frmAddAccount, I have a field PatientID. When I type in this ID, I would like the subform field PrimaryInsurance to populate with information from the a field in another table - tblPatient. I realize that I could use a query...