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

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Good stuff. Good luck with your project.
 
Upvote 0

Forum statistics

Threads
1,215,425
Messages
6,124,825
Members
449,190
Latest member
rscraig11

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