Search results

where should i put this code? I tried putting it in the to_department after update it didn't work. I tried to put it in the unit listbox it didn't work as well.

the code worked, thanks but something else came up :confused: attached is snapshot of what's going on I have the department listbox when i choose a department the unit listbox (unbound) lists the units I have in that department and when I choose a unit its unit_no is saved in to_unit (a field in...

Could anyone help me and tell me where is the mistake in the following code? I can't get it to work Private Sub units_AfterUpdate() Me.to_unit.Value = DLookup("unit_no", "unit", "[unit_name]=" & Me.units.Value) End Sub units => is an unbound listbox after a unit is chosen from units...

I have two list boxes Department listbox and Unit listbox I want whenever I choose a department from the listbox all the units under that department to appear in the unit listbox. whenever the department value changes only the units under that department appear in the other listbox. I tried...

It worked Thank you :)

I started developing small database and forms to help us at work in creating work orders that we use. I have 5 tables: 1. employee (emp) table 2. department (dept) table 3. unit (unit) table 4. transaction (trans) table 5. transaction detail (trans_detail) table I have four department, and...