Function Me.Refresh excluding a subform

[rui_parente]

Good afternoon



I have a DB and in one of the forms there is a subform.

I need to use the function Me.Refresh to update a date.

I don't want to, however, to update the subform that i have associated with this form.

Is there any way (or code) that I can use to not update the subform? Or for example use the function Me.Refresh to update a single control of the form?

I've tried the function Me.Requery and it didn't work.

Thank you

[pbaldy]

How about

Me.ControlName.Requery

[rui_parente]

Sorry. No good. Error "Message Method or Data Member not found".

[pbaldy]

Did you change the control name? And adjust to the full reference if it's on a form different than the code?

Forms Refer to Form and Subform properties and controls

[John_G]

Did you try just setting the control to the new value?

me![ControlName] = NewDateValue

However, if the control you are updating affects the data that is shown in the subform, then you probably can't change the date value without the subform being updated as well.

[rui_parente]

The Refresh part of the Code is as follows:

Dim ano As String
ano = right(Date, 2)
Me.Nº_do_PA = num & "/L-EFLI/" & ano
Me.[Data do PA] = Date
Me.Refresh

[rui_parente]

pbaldy, i did that.

But the problem subsists... When I use the code that contains the Me.Refresh part the data in the subform erases.

The code is activated through a button in the main form and the control is also in the main form. The problem is the subform.

[rui_parente]

Hi John_G.

Is it possible to do it simultaneously?

[pbaldy]

Can you post the db here?

[John_G]

Is it possible to do it simultaneously?

I'm not sure what you mean by "simultaneously" - can you explain, please?

What data (i.e. controls) do you use to link the subform to the main form?

[Missinglinq]

I think that the question

...What data (i.e. controls) do you use to link the subform to the main form...

is important because your statement

...When I use the code that contains the Me.Refresh part the data in the subform erases...

suggests that you're changing a value on the Main Form that is used to relate the Main Form/Subform Records...when it changes there is no longer a related Record in the Subform, hence the 'erasing' of data in the Subform.

Linq ;0)>

[rui_parente]

Correct Missinglinq.

I figured it out in the weekend.

It has nothing to do with the Me.Refresh I was refering to.

Thanks to you all, neverthless, for the help.

I think that the question


is important because your statement


suggests that you're changing a value on the Main Form that is used to relate the Main Form/Subform Records...when it changes there is no longer a related Record in the Subform, hence the 'erasing' of data in the Subform.

Linq ;0)>