AfterUpdate Problem

[IainGreen]

Hi,

I have a form forHighways which lists job numbers & details for road repairs to be made. I have a combo box (cmbCategory) which the user selects a job category from a list which states whether the job is Misc., Kerb, Emergency etc...

There is also a text box (txtCostCentre) which I want to be populated by an AfterUpdate query on the above cmbCategory box. I.e. if The category selected by the user is 'Emrgency' then the Cost Centre is automatically populated with the corresponding code.

The AfterUpdate event must get the relevant Cost Centre codes from a table (tabHighways), which has 3 columns:

1. Category Code
2. Category i.e. Emergency etc...
3. Cost Centre Code

I'd be grateful for any help with the AfterUpdate code.

Thanks.

 

[scottian]

try using dlookup.

Be ALERT - Your country needs Lerts