I hope somebody can help with some of my Access problems.
1.
I have a field “OfferNo” which is primary key, auto number (format start at 300). When I create search combo box in form, it does not retrieve the result of “OfferNo”, I suspect that it is due to format 300 because if auto number starts at 1 it works fine or search on another field.
Any tips?
2.
I have field’s:
If “ActivateOrder” is Yes - “OrderNo” = “OfferNo” (automatic)
How to do?
1.
I have a field “OfferNo” which is primary key, auto number (format start at 300). When I create search combo box in form, it does not retrieve the result of “OfferNo”, I suspect that it is due to format 300 because if auto number starts at 1 it works fine or search on another field.
Any tips?
2.
I have field’s:
- “OfferNo” (auto number)
- “OrderNo” (number)
- “ActivateOrder” Yes/No Check box
If “ActivateOrder” is Yes - “OrderNo” = “OfferNo” (automatic)
How to do?