Changing form from modular to data sheet

mtagliaferri

Board Regular
Joined
Oct 27, 2004
Messages
122
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
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Andrew Fergus

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,432
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
 

Watch MrExcel Video

Forum statistics

Threads
1,114,059
Messages
5,545,759
Members
410,704
Latest member
Cobber2008
Top