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 and the DOUBLE CLICK option...
How can I get these features back???
Thanks
Marco

 

[edtab]

In design view of your form, change the default view to "Continuous form".
You should get back your combobox.

 

[stopher]

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 and the DOUBLE CLICK option...
How can I get these features back???
Thanks
Marco

What do you mean exactly ? You should still be able to double click on the combo cell in data sheet view and the event will fire (assuming you still have an event there). Equally, the Not In List will still run if you put something in that is not in the list (assuming you have coded the event and the LimitToList property is set).

Check that the code is still there and that it is in the event list
Check that the code is executing with a debug statement.
Check that the LimitToList property is set to yes.

If all else fails, delete each event and re-enter - I've found on very rare occasions the compiler loses the plot for no obvious reason.

hth
Stopher