Can a field auto-fill from previous entry in seperate field

[medalert]

Hi,
I've just returned to work after kids and started managing a large Access database related to health, back-tracking over many years.

Currently in filling a form we physically enter:
Apples 2.2
red apple 2.4
red apple cut 2.45
Oranges 5.6
Cucumbers 8.5

Is it possible to get field 2 to automatically fill with a number code due to the text typed in field 1?

FWIW, I'm confident at more basic Access e.g making follow on default value = Dlast("field""table") type stuff but the more complex stuff I haven't touched since Uni over a decade ago and you will need to be gentle while I blow away the cobwebs. Thanks Alex

 

[John Big Booty]

Welcome to the forum.

You could use the DLookup() function to populate your second field.

Another method would be to use a combo to select items in your first filed, then populate the second filed from the combo using;

= Me.ComboName.Column([B][COLOR="Red"]x[/COLOR][/B])

Where x represents the column number that holds the data you wish to display (this column need not necessarily be visible). Remembering that the columns in a combo, or list box for that matter, are numbered from zero on up.

 

[medalert]

Thanks John, I'll give it a go today and hopefully get it working more efficently Hand entering is working but it would save the data entry people time if I could get it to link. Alex

 

[John Big Booty]

The sample posted here demonstrates the method.