form & fields

[Guest_imported]

Hi,

I have a table: Store
and fields: Store_Number & Store_Name

Would I be able to display the Store_Name once a user enters a store number in the Store_Number field on the FORM VIEW?

e.g.
Store No : 1004
Store : Wonderland (this would appear in a label/text box? once you leave that field, if it's a valid store_no on the list)


Any help will be greatly appreciated!
Thanks.

 

[braindead2]

create a combo box name it combo1
set its source to bring in the store_number and store_name
set the column count to 2 and its column widths to "1";0
create a textbox to display the store name
set the textboxes source to =[combo1].[Column](1)