Search results

Thank you John. You're right - the concept of "wasting" an autonumber is a bit obsessive. But say, for example, the autonumber is an Invoice Number and your Accounting dept doesn't want any gaps in invoice numbers? There has to be a way to handle it. I read about using the Default Value...

Thanks to Keith & Gary, but... Keith - the default value is sitting in the description field, I hit "enter" and nothing happens. Focus moves to autonumber field, which does not increment. Gary - "...after the update of description field..." Yes - but the key is - what event or function...

Hello - I'm looking for detailed information (event structures/orders/variables) surrounding autonumber and record update events. Specifically, I have a form for adding new records to a table. Some of the fields are linked to other tables (displayed in combo-boxes). If a user tries to enter...