Autofill option on forms in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to use the option "Autofill" on my forms on Access,
but really sure how to do this.
Example: Type In "Jane"
Autofills: "Doe"
Example:Type in "1"
Autofills: "2"
 
Hi,


With a join, you can use autolookup, or, in general, in the After Update
event of the CONTROL, Me.Control1, you can "push" values in other controls:


If Me.NewRecord then
Me.Control2 = DLookup( "address", "Companies" , "ClientName=""" &
Me.Control1 & """" )
End If


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top