autopopulate

[bridgeman]

I am creating a data entry form to populate a main table. I am trying to get
2 forms in the field to auto populate with info based on the answer to a
previous field. Something like this in my activity code field If the entry is
487, then the next field (type of unit) should autopopulate Acre, the next
field (cost per unit) should autopopulate 398.99. I made a table just for
those fields. I just cannot get it to work right. There are other fields in
the form, but those will be entered manually.
Any insight. I am just learning access and any help is appreciated.

 

[Jeanette Cunningham]

Hi,
You can use a Dlookup on the table you created.
Something like:
If Not IsNull(Me.txtEntry) Then
Me.txtUnit = DLookup("[Unit"], "TheTableName", "[EntryFieldName] = " &
Me.txtEntry)
Me.txtUnitCost = DLookup("[UnitCost"], "TheTableName", "[EntryFieldName]
= " & Me.txtEntry)
End If

Note:
txtEntry is where you type 487
EntryField is the name of the field that has 487 in it

Jeanette Cunningham

 

[Steve Schapel]

Bridgeman,

The ideas in this article may be relevant to your question:
http://accesstips.datamanagementsolutions.biz/lookup.htm