Changing form from modular to data sheet

mtagliaferri

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

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Andrew Fergus

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,452
Office Version
  1. 365
  2. 2021
  3. 2016
Platform
  1. Windows
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,176,423
Messages
5,903,032
Members
435,003
Latest member
farooquecool

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