Dear all,
Please find attached my zip,
There is two little things that I can't figure out.
pls check 'frmAssignments' --> combo box: 'Object Type'.
1. when clicked, the combo box shows 3 columns. Column 3 shows the prime key, but I would like it rather to show the associated 'text' of the PriceCategory tbl --> what am I doing wrong (and what is different from column 1&2 which work fine) ?
2. After a selection, the combo box gives an error, ("the value you entered is not valid for this field...")
Any tips would be highly appreciated.
I'm still learning bits and pieces every day.
Kind regards,
Vernon
Please find attached my zip,
There is two little things that I can't figure out.
pls check 'frmAssignments' --> combo box: 'Object Type'.
1. when clicked, the combo box shows 3 columns. Column 3 shows the prime key, but I would like it rather to show the associated 'text' of the PriceCategory tbl --> what am I doing wrong (and what is different from column 1&2 which work fine) ?
2. After a selection, the combo box gives an error, ("the value you entered is not valid for this field...")
Any tips would be highly appreciated.
I'm still learning bits and pieces every day.
Kind regards,
Vernon