Delete Record On Subform with Control on Form

WarHorse

Registered User.

Local time

Yesterday, 21:27

Joined

Apr 21, 2004

Messages

18

• Oct 15, 2004

• #1

I am guessing that this is an easy one for anyone but me.

How do I delete a record on a subform from the main form?
I used to put a command button on the subform, but now I can't because the sub form is a datasheet.

Thanks dudes (and chicks, if there are any?)

-Matt

 

M

misunders2d

Registered User.

Local time

Today, 04:27

Joined

Sep 23, 2004

Messages

13

• Oct 16, 2004

• #2

Hi, dude..
Have you tried this one:

Me.frmSub.Form.Recordset.Delete
Me.frmSub.Form.Recordset.MoveNext

 

WarHorse

Registered User.

Local time

Yesterday, 21:27

Joined

Apr 21, 2004

Messages

18

• Oct 18, 2004

• #3

Thank you,

It worked like a charm. I told you it was an easy answer. Can't wait tell I know enough to answer some of these.

Later,
Matt

 

T

TallMan

Registered User.

Local time

Yesterday, 22:27

Joined

Dec 5, 2008

Messages

239

• May 5, 2010

• #4

AWESOME! This helped me out as well!!! Thanks misunders2d!

 

S

shabbaranks

Registered User.

Local time

Today, 02:27

Joined

Oct 17, 2011

Messages

300

• Oct 28, 2011

• #5

I want your children chicks and dudes... Worked for me too!!

 

J

JackAtAllTrades

New member

Local time

Yesterday, 19:27

Joined

Nov 21, 2013

Messages

1

• Nov 21, 2013

• #6

Years pass, and this is still good information. I used it today.

 

C

Corsica

Registered User.

Local time

Today, 02:27

Joined

Sep 20, 2016

Messages

19

• Oct 8, 2016

• #7

Ditto.

Many thanks.