Lookup values and write in a Table

[dSurvivalist]

Hi,

I need to create a form with a text box and a command button; in the text box i will enter a value and when i click the button, i need it to lookup the value i write in a query and write it to a specified table's 1st column (has a column name) while also writing the other values in specified columns in the query which i lookup.
I need to know where and how to start. The tables and queries are all ok. Could anyone please help?

 

[vicissitude]

I am not an expert in this stuff but i will help you if i can.

You need to enter a value into a text box on a form, have a query triggered by a command button use that value to write that value and others (filtered by that value?) onto a table, is that correct?