viperstingray
Registered User.
- Local time
- Yesterday, 16:23
- Joined
- May 31, 2005
- Messages
- 87
I have been away from access for a while now and I am sure that this is simple. I tried a search but found nothing.
The issue:
A)The user enters in a product number, if not found then a message appears to tell them so...this I know how to do
B)If the product is in the table then I would like it to display some of the fields on the form.
EX: Prd # 0659875
MSG = does not exist
ExB) prd #: 0584785
Reason No.:1
Description: abcdefg hijklm nopqr stuvwxyz
So the whole this is how do I populate the text boxes that display the fields with the proper searched critera (prd. no.)
Thanks,
viper
The issue:
A)The user enters in a product number, if not found then a message appears to tell them so...this I know how to do
B)If the product is in the table then I would like it to display some of the fields on the form.
EX: Prd # 0659875
MSG = does not exist
ExB) prd #: 0584785
Reason No.:1
Description: abcdefg hijklm nopqr stuvwxyz
So the whole this is how do I populate the text boxes that display the fields with the proper searched critera (prd. no.)
Thanks,
viper