dlookup

[Guest]

i need the record, when i enter a value(like supplier id) the complete record
should return. like v look up in excel, For this we want to write code or is
there any way to wizard. (may be in access dlookup)
eg.

FRTBNN BANANA QTY UNIT RMK DESCRIPTION

In this FRTBNN is my primary key, when i enter this value i have get return
valus of the balance record.
is some body can help me.

 

[Allan Murphy]

On your form use the combo drag the combo box down from your toolbox menu
and place it in the header of your form by sizing the size etc. .
If you have a table or query as your record source when you place it on your
form the last option in the wizard should be select a record based on the
selection in my combo box or something similar

Allan Murphy
Email: (e-mail address removed)