access form search record before delete

[Steven]

Hi,

Would need some thought about using a button of the existing form to search
record before deleting it.

Any quick help is very appreciated.

Steve

[storrboy]

On Mar 20, 6:32 pm, "Steven" <[e-mail]:

Hi,

Would need some thought about using a button of the existing form to search
record before deleting it.

Any quick help is very appreciated.

Steve

Search for what? Not much to go on.

[Steven]

I am searching ID (pk) for the matching record, then delete it. My thought
is to have a main form of data entry, from which there is an additional
button to open a query asking for the ID then retrieve the record in a
subform. Currently I can delete the record and close the subform, but the
main form have "#deleted" on all columns. Not until you close the main
form and re-open it, they are there.

I would like to know if there is 'refresh' code put in the button or the
Delete Procedure to make the main form sync simultaneously for the record
without re-opening.

Appreciated!
My problem is

"storrboy" <st******@sympatico.cawrote in message
news:11**********************@y66g2000hsf.googlegr oups.com...

On Mar 20, 6:32 pm, "Steven" <[e-mail]:

>Hi,

Would need some thought about using a button of the existing form to
search
record before deleting it.

Any quick help is very appreciated.

Steve

Search for what? Not much to go on.

[Wayne Gillespie]

On Wed, 21 Mar 2007 23:36:57 GMT, "Steven" <sc*****@verizon.netwrote:

>I am searching ID (pk) for the matching record, then delete it. My thought
is to have a main form of data entry, from which there is an additional
button to open a query asking for the ID then retrieve the record in a
subform. Currently I can delete the record and close the subform, but the
main form have "#deleted" on all columns. Not until you close the main
form and re-open it, they are there.

I would like to know if there is 'refresh' code put in the button or the
Delete Procedure to make the main form sync simultaneously for the record
without re-opening.

Appreciated!
My problem is

"storrboy" <st******@sympatico.cawrote in message
news:11**********************@y66g2000hsf.googleg roups.com...

>On Mar 20, 6:32 pm, "Steven" <[e-mail]:

>>Hi,

Would need some thought about using a button of the existing form to
search
record before deleting it.

Any quick help is very appreciated.

Steve

Search for what? Not much to go on.

After the record is deleted in your code put Me.Requery, or if the delete code
is being run from the subform put Me.Parent.Requery

Wayne Gillespie
Gosford NSW Australia

[Ste]

The Me.parent.requery from subform is not working as the way it should.
I put it in AfterUpdate event.

The subform is open when a button is clicked from mainform, and the delete
action is from the subform.

Don't know what is the next.

Any help is appreciated.
"Wayne Gillespie" <be*****@NOhotmailSPAM.com.auwrote in message
news:i2********************************@4ax.com...

On Wed, 21 Mar 2007 23:36:57 GMT, "Steven" <sc*****@verizon.netwrote:

>>I am searching ID (pk) for the matching record, then delete it. My
thought
is to have a main form of data entry, from which there is an additional
button to open a query asking for the ID then retrieve the record in a
subform. Currently I can delete the record and close the subform, but the
main form have "#deleted" on all columns. Not until you close the main
form and re-open it, they are there.

I would like to know if there is 'refresh' code put in the button or the
Delete Procedure to make the main form sync simultaneously for the record
without re-opening.

Appreciated!
My problem is

"storrboy" <st******@sympatico.cawrote in message
news:11**********************@y66g2000hsf.google groups.com...

>>On Mar 20, 6:32 pm, "Steven" <[e-mail]:
Hi,

Would need some thought about using a button of the existing form to
search
record before deleting it.

Any quick help is very appreciated.

Steve
Search for what? Not much to go on.

After the record is deleted in your code put Me.Requery, or if the delete
code
is being run from the subform put Me.Parent.Requery

Wayne Gillespie
Gosford NSW Australia