[Auditor Name]="[Forms]![100-Provider Form New]![Combo312].[Column](1)"
this combo box has one column only ( the name )
this macro does not work
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: this macro does not work
You don't need to specify the column since the combo only has one column. (It returns the bound column value by default.)
If I recall correctly, the first column of a combobox has a value of 0 (not 1)
Try this:
[Auditor Name]=Forms![100-Provider Form New]![Combo312]
If I recall correctly, the first column of a combobox has a value of 0 (not 1)
Try this:
[Auditor Name]=Forms![100-Provider Form New]![Combo312]
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.