After update event combo shows previous record in subform

[tekaccess]

Hi

When i select a particular item, from my combo box (supplierid) if there is no record on the subform against that supplierid then subform shows the pervious record.
I want to show some message if there is no record on the subform against a combo selection.

Thanks

 

[TheAceMan1]

How are ya tekaccess . . .

Have a look at the [blue]DLookup[/blue] function? . . .

See Ya! . . . . . .