Hi....am totally stuck!!!
I've got an order form from which the user can chose a shipping type e.g. postage, express etc. I have a table caled 'shippers' which contains the field 'default cost' which holds the information i want generated. The problem is that i have no idea how to generate the 'freight cost' (default price) on my order form. As its a data type 'currency' i can't even try and do a lookup via.Row source...
please can anyone help?!?
I've got an order form from which the user can chose a shipping type e.g. postage, express etc. I have a table caled 'shippers' which contains the field 'default cost' which holds the information i want generated. The problem is that i have no idea how to generate the 'freight cost' (default price) on my order form. As its a data type 'currency' i can't even try and do a lookup via.Row source...
please can anyone help?!?