S
siggy
I use:
=DLookUp("COMMODITY","RATES","Rate_Check = [RATES.Rate_Code]")
in a form field the display textual data based on what is entered in a form
field.
the Problem is that this look-up data is NOT displayed right away
( as soon as the first field is entered ) ... it is only displayed after
the record
is saved...
I would like the field to be populated with the LOOK-UP data as soon
as the first field text is entered and the user TABS out of that field...
siggy
=DLookUp("COMMODITY","RATES","Rate_Check = [RATES.Rate_Code]")
in a form field the display textual data based on what is entered in a form
field.
the Problem is that this look-up data is NOT displayed right away
( as soon as the first field is entered ) ... it is only displayed after
the record
is saved...
I would like the field to be populated with the LOOK-UP data as soon
as the first field text is entered and the user TABS out of that field...
siggy