Refresh a form using VBA code

[Khalil Handal]

Hi,


I have a form Form1 that shows several records. Double click on the record opens form2 to show details for that specific record.
I have a cmdMarkDeleted on form2. If the user clicks on the cmdMarkDeleted the record is marked as deleted record, Form2 closes and I am back to Form1. This record that is marked as deleted should not be shown on Form1. So I have to press the F5 key to refresh Form1.

Can I do this programmatically to refresh Form1 without having to press the F5 key?

Any help is appreciated
Khalil

[Bob Fitz]

I think you may need to Requery rather than Refresh. Try:

Forms!Form1.Requery

[mike60smart]

Hi Khalil

You should Close Form1 when you Open Form2 using something like this:-

DoCmd.Close , ""
DoCmd.Close acForm, "Form1"
DoCmd.OpenForm "Form2", acNormal, "", "", , acNormal

Then on the Close of Form2 open Form1

[Bob Fitz]

Hi Khalil

You should Close Form1 when you Open Form2 using something like this:-

DoCmd.Close , ""
DoCmd.Close acForm, "Form1"
DoCmd.OpenForm "Form2", acNormal, "", "", , acNormal

Then on the Close of Form2 open Form1

While that would solve the OP's original problem it won't help if the user needs to look a records on form1 while form2 is open.

[Khalil Handal]

Hi,
I tried the requery option first and it works fine.
I will try closing the forms and reopening them and see how it works.

I was wondering the difference between: (Requery and Refresh) since they both gave the same result.

Thanks for both of you.

[Bob Fitz]

Hi,
I tried the requery option first and it works fine.
I will try closing the forms and reopening them and see how it works.

I was wondering the difference between: (Requery and Refresh) since they both gave the same result.

Thanks for both of you.

Glad you have it working. If Refresh works for you then stick with that. See link for differences: https://www.599cd.com/tips/access/re...ted%20records.

I would advise against the closing and reopening of the original form.

[mike60smart]

Hi Bob

I agree but I also wonder why there is a need to open Form2 at all?

Surely if there is a Control for MarkingAsDeleted which would I assume be a YesNo Checkbox, why not just select Yes on Form1. Then there is no need to open Form2?

[Bob Fitz]

Hi Bob

I agree but I also wonder why there is a need to open Form2 at all?

Surely if there is a Control for MarkingAsDeleted which would I assume be a YesNo Checkbox, why not just select Yes on Form1. Then there is no need to open Form2?

We would need to OP to answer that one but perhaps the second form would be needed to reinstate a deleted record.