Form variables in queries?

[dalascby]

I am very new to Access so forgive me if this seems like a very elementary task. Here is what I need to do:
1)
I have five fields on a form, lets call them var1, var2,...var5. Var1 is an unbound text field, when I enter a code into var1 and hit enter (or tab, or click into another field) I want the value of var1 to be used in a query (if a query is best to use) to extract data from a table and fill in var2 through var5. (The value that I key into var1 will correspond to a field/column called "itemno" in the table...itemno is unique within the table.)

2)
After vars 2 through 5 are filled in after step 1 above I want the ability to change (key over) any one of those values(var2-5) and have it actually change the value of that column ,for that record, in the table (update the record in other words.)

Thanks in advance for any help that someone can give me on this.

 

[RoyVidar]

Hi!

If i understand you correct, all the controls are bound to one table or query.

1)
The perhaps easyest way, would be to insert a ComboBox-control in your form. When using the Wizard, choose the "I want the combo to find a record on my form....", which should do the trick.
2)
I'm not sure I understand your question, but if it's simly an update of the current record, you should be able to to this after applying 1)

Roy-Vidar

 

[dalascby]

Thanks for responding. I also posted this question on another thread, take a look and tell me what you think. May you can expand on the other responses. Thanks.

thread701-129551