Look-up Data

[Dale Cleeve]

I have data stored in a query containing the fields: object name, price, discount and balance. I want to type an Object Name into a field on a form and on accepting it the form displays the other three fields (above) containing the relevant data for that field. Can anyone help? I'm not the most access literate of people - just a dumb techy!! I look forward to your reply.

 

[Abby N]

Hello Dale. Here's what you do. Create a form based on your query. Place your, Price, Discount and Balance fields on the form. Add an unbound control on the form instead of the 'Object Name' field. For the purposes of these instructions I'll call it 'SearchName'. Now code the SearchName field's 'After Update' event with:

Me.Requery

In your query, set the 'Object Name' criteria to SearchName. That's all there is to it. Good luck.

~Abby