Changing form from modular to data sheet

mtagliaferri

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

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

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
 

Forum statistics

Threads
1,141,916
Messages
5,709,327
Members
421,629
Latest member
RLRobinson

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top