By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,842 Members | 2,148 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,842 IT Pros & Developers. It's quick & easy.

access form search record before delete

P: n/a
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
Mar 20 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Mar 20, 6:32 pm, "Steven" <sche...@verizon.netwrote:
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.

Mar 20 '07 #2

P: n/a
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" <sche...@verizon.netwrote:
>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.

Mar 21 '07 #3

P: n/a
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" <sche...@verizon.netwrote:
>>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
Mar 22 '07 #4

P: n/a
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" <sche...@verizon.netwrote:
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

Mar 22 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.