Hi all,
I want to open a form to enter only one new record. So, I set the "Data Entry" property of the form to 'Yes.'
However, I don't want to be able to add any other records except for the first new one. Unfortunately, "Data Entry" mode allows multiple new records to be created. Again, I only want one new record to be available.
The situation I am trying to avoid, is when someone uses the scroll wheel on the mouse, they get sent to the next new record, instead of scrolling down the list of a combo box (Access 97). Thus, all the data looks as if it is lost. I would force entry on the first field, make a property change and RecordSource change, based on that first field. Sadly, the combo box is the first field on the form.
Your help is appreciated.
I want to open a form to enter only one new record. So, I set the "Data Entry" property of the form to 'Yes.'
However, I don't want to be able to add any other records except for the first new one. Unfortunately, "Data Entry" mode allows multiple new records to be created. Again, I only want one new record to be available.
The situation I am trying to avoid, is when someone uses the scroll wheel on the mouse, they get sent to the next new record, instead of scrolling down the list of a combo box (Access 97). Thus, all the data looks as if it is lost. I would force entry on the first field, make a property change and RecordSource change, based on that first field. Sadly, the combo box is the first field on the form.
Your help is appreciated.