Field updated instantly

Cantor · Jul 20, 2000

Hi, It's the second time I ask this, but this time I've put a more descriptive subject! I've 2 fields : the area_ID and the Surface. They are both in the same table (tblArea). So, when user enter the area, in the AfterUpdate event I write the following code to updated the field Surface instantly: Private Sub area_ID_AfterUpdate()     [Surface] = DLookup("area_surface", "tblArea", "area =[area_ID]&quot

End Sub The Surface should appears in the surface field of my form, no? What's wrong with this code? Is this the good way to make it? Any help is welcome, Cantor

famousb · Jul 20, 2000

if your table name is "tblArea" your field names are "area_ID" and "Surface" then your code should be Private Sub area_ID_AfterUpdate()     Me.[Surface] = DLookup("Surface", "tblArea", "(tblArea.area_ID) = [forms]![YourFormName]![area_ID]&quot

End Sub just change the red to reflect your form name.  this is assuming your fields have the same name in the table as they do on the form. Brian Famous <a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a> <a href= > </a>

Cantor · Jul 20, 2000

Thank you famousb it works and makes me happy!

Cantor

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Field updated instantly

Cantor

Programmer

famousb

Programmer

Cantor

Programmer

Similar threads

Part and Inventory Search

Sponsor