save text box data to table

[mkelly]

save text box data to table?????

I have a form that is controlled by a query,
on the form is a text box that is auto populated by a combo box,
how can I save the value in that text box to a table field???

Query: job summary query1
Form: job form
combo box: combo17
text box: cost per copy 1

I want to save this text box value to:
Table: job table
field: CPC 1

Can this be done? If so how can I do it??

Any help greatly appriciated....

 

[dcx693]

You'll need to include the CPC 1 field from the underlying table in your query. Then bind the "cost per copy 1" field on the form to the "CPC 1" field coming from the query.

 

[mkelly]

thanks, one more question how do i bind them?

 

[mkelly]

thanks Pat