Help in coding

[Manolis Nikolidakis]

hi everyone,


i have a table called "Margin" and in this table i have a field also called "Margin"

In a form called "costing" I have an unbound txt field called "txtMargin"

in the same form i have two combo boxes, called ProductCategory and ProductCompanyName

what i would like to to is the below:

I want to enter a price in the txtMargin which will update the field "Margin" in the table "Margin" based on the value i choose from the combo ProductCat. The purpose is to run a query and see costing relults for single products which belong to the same product category.


Any help is highly apreciated.

Thanks in advance,
Manolis

[ranman256]

in the form, bind the form to the table tMargin,
bind the txtMargin box to field Margin.

youll have a comobox to ProductCat, when user picks the item, set the txtMargin

sub cboBox_afterupdate()
  txtMargin = cboBox
end sub

[Welshgasman]

Otherwise use an Update query with the combo value as criteria.