Hard to create the relevant query without knowing the structure of the tables involved (as well as the data types of their fields)... in addition to that, also include info regarding which control (eg. textbox, combobox) provides the data to which fields.

Also, will this be an UPDATE query, which updates an existing record, or an INSERT query which adds a record to the table Which do you need, pls explain more clearly.