Form Coding

  • Thread starter Thread starter Curtis Stevens
  • Start date Start date
C

Curtis Stevens

Do I not have this correct?

In VB for a form, I want to call a particular field from the query the form
uses. The query has multiple tables attached to or in it. Affiliates is one
of the table names. Email is the name of the field in Affiliates.

So, shouldn't the code be if I want to reference that box?

Me.Affiliates.Email

It isn't work...

Curtis
 
Nevermind, realized I didn't have a box on my main form calling or dislpaying
that field, the code I was using was in an event for a button...

Curtis
 
Each field in the form's recordset needs to have a unique name, so that you
don't include a reference to the table when referring to the field. Alias
them using the AS query word if you have to.
 
Back
Top