Delete and Open subform record from form?

behedwin

Active Member
Joined
Dec 10, 2014
Messages
399
Hi

Here is a link to my test project: https://1drv.ms/u/s!AnrRbil63rR_x0zxxMXkT7jVvwRY
I hope someone are willing to help me with two things.

If you open the form called Staff Profile Form
It contains the data from table staff profile and data from contract information.

I like how the subform is displayed in my form.
However i want my users to only be able to add data to the subform by opening a new form window and filling out data in a form.
And i also want my users to delete a row by selecting it and then pressing a button.

How can i make my subform view look more like a plain listbox and how can i fix so users can delete rows in the subform?
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Forum statistics

Threads
1,223,893
Messages
6,175,241
Members
452,622
Latest member
Laura_PinksBTHFT

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
Back
Top