Automatically fill in field

[taylornow]

Is there a way to automatically fill in a field when another field is keyed? Example - the county automatically enters when the city is keyed in. Possilbe??

Thanks in advance
Taylor

 

[dneufarth]

The Dlookup function in the field on your form to be filled automatically works well for this.


Dave

 

[Cagliostro]

When you design a database, you can create a column, and to put in DefaultValue your expression.
for example table has columns ID, xx, yy and you want the field zz=xx+yy. You just add this column in design mode and in DefaultValue put xx+yy. John Fill

 

[Rohdem]

Using the after update event of the text box, you can assign a value to another control:

Private Sub Zip_AfterUpdate()
Me.State = DLookup("ST", "Z5LL", "[Zip] = '" & Me.Zip & "'&quot
Me.City = DLookup("City", "Z5LL", "[Zip] = '" & Me.Zip & "'&quot
Me.Refresh
End Sub Mike Rohde
rohdem@marshallengines.com

 

[taylornow]

Thanks a bunch everybody- I shall give it a go !

 

[Cagliostro]

I just tried to do as I sayd, but it doesn't work. Instead it you can just use a query
select xx,yy,(xx+yy) as zz from tablex. zz will be always autoupdatable. John Fill