MS Access problem

Aug 11, 2018
Reaction score
I hope somebody can help with some of my Access problems.

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?

I have field’s:
  • “OfferNo” (auto number)
  • “OrderNo” (number)
  • “ActivateOrder” Yes/No Check box

If “ActivateOrder” is Yes - “OrderNo” = “OfferNo” (automatic)
How to do?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question