Update SubForm on selection 1

[ragu111]

in my main form i have a option called "Duty" after selecting this option i want to subform to be auto filled as below

subform Field       Criteria
-----------------------------
masterID            = [mainform].[id]
charge_code         = "C"
Charge_Detail       = "Customs Duty"
Charge              = "5000"

this is just to automate the porcess where the user no need to enter the subform. when ever duty in involved by selecting the charges will be automatically updated.

can some one help me with the code

 

[Remou]

You can use the After Update event for the Option and, I guess, an If statement, to update the subform controls. This:

http://www.mvps.org/access/forms/frm0031.htm

has notes on how to refer to subform controls.

 

[ragu111]

anyone else..??

 

[TheAceMan1]

How are ya ragu111 . . .

Other than not knowing if Duty is an [blue]option button[/blue], [blue]checkbox[/blue], or [blue]textbox[/blue], [blue]Remou's[/blue] post sets you on the straight and narrow!

See Ya! . . . . . .