Search results

After researching for a solution it appears that this code work: Private Sub streetAddress_BeforeUpdate(Cancel As Integer) If IsNull(DLookup("[streetAddress]", _ "SurveyData", _ "[streetAddress] = """ & Me.streetAddress.Text & """")) = False Then Cancel = True MsgBox "Address already exists"...

Opps, I didn't see thread tools and was looking for and obvious subscribe button. TY for the info. Code where 'streetAddress' is the field in the 'SurveyData' table: Private Sub streetAddress_BeforeUpdate() If DCount("*", "SurveyData", "[streetAddress] = " & Me.streetAddress.Text) > 0 Then...

Replying to 'subscribe' to thread. Having save issue and none of you above code worked for me either. I did, of course, adjust the table and field names properly.

I think I may have just learned a quirk of Access. Last thing I did yesterday was to enter that VBA without it working. It was populating the text box in the form but NOT adding the info to the field on the 'SurveyData' table. Today, all is right with the world. I was racking my brain on why...

I am not storing redundantly. In the 'SurveyStatusChoices' table the fields are: Choice, Surveyed, Occupied and Vacant. There are 5 'choices" displaying in the drop down of the form pulled from this field. In each of these choices there is a different combination of 1 or 0 in the three following...

I need a dropdown choice to auto populate other fields. The choices in the dropdown come of course from another table. -Main table is 'SurveyData'. -The field 'surveyStatus' is the lookup column pulling from the table 'SurveyStatusChoices'. -In that table the fields 'totalSurveyed'...