Changing form from modular to data sheet

[mtagliaferri]

Hi all,
I have built a form in tabular mode with a combo box named "STAFF NUMBER" I have a code for a NOT IN LIST event and when double clicking on it it will open the STAFF form in adding mode...it works OK... I have now changed the properties of the form to data sheet wich gives me a better view of all the information, but I have lost the NOT IN LIST event and the double click option..
How can I get these features back???
Thanks
Marco

 

[Andrew Fergus]

Hi Marco

What version of Access are you using?

If I attach code to a double click event on a combo box and display the form in datasheet mode, then I can get another form to open. The 'not in list' event also works but only if I set the 'Limit to List' preopty for the combo box to 'Yes'.

Another way around this is to create a continuous form that looks like a datasheet so that your code still works.

HTH, Andrew