Subform refresh

[Ruegen]

Probably a common question and I did a search for the answer without much luck..

Trying to refresh/requery a subform and it isn't working.

The subform name is subPaymentsClusterList, the suform Form is frmPaymentsClusterList

the main form is frmPayments

The field is PaymentReceived1st with some After update code in it already.

I was hoping to have the subform update after the input was made.

The field on the subform is from a query that calculates 2 fields on the mainform. (so I'm guessing the .requery is required)

[June7]

What is the code? What happens - error message, wrong results, nothing?

It is odd for a subform to calculate with fields that are on main form. Why are you?

Want to provide db for analysis? Follow instructions at bottom of my post.

[Ruegen]

What is the code? What happens - error message, wrong results, nothing?

It is odd for a subform to calculate with fields that are on main form. Why are you?

Want to provide db for analysis? Follow instructions at bottom of my post.

I think it is time I did - is there a quick way to purge all table data without having to break table relationships?

[June7]

If you have Enforce Referential Integrity and Cascade Delete Related Records checked, delete parent and child records will go with. http://office.microsoft.com/en-us/ac...001173951.aspx

Do you really need to purge all data? Some records helpful in testing. Just remove confidential (phone, address, cc, ssn).

[Ruegen]

If you have Enforce Referential Integrity and Cascade Delete Related Records checked, delete parent and child records will go with. http://office.microsoft.com/en-us/ac...001173951.aspx

Do you really need to purge all data? Some records helpful in testing. Just remove confidential (phone, address, cc, ssn).

10,000 plus records... boss won't let me send it otherwise.

oh and lock violations?

[Ruegen]

eh.. I just keep getting into roadblocks trying to purge the data necessary (there is a lot).



These are the related tables to the forms



This is the form (you helped me with this form earlier and gave me a better vba calc but I want to add some more to it to also update the subform).

[June7]

What is the RecordSource for each form?

What about lock violations? Not something I've paid much attention to.

[Ruegen]

What is the RecordSource for each form?

What about lock violations? Not something I've paid much attention to.

subform

main form

[June7]

That confuses me. Why would form and subform have same tables (tblSchools, tblTeacher, tblJncTeacher) in their RecordSource? Why a subform to add values from the main form? I don't understand what you are trying to accomplish.

[Ruegen]

That confuses me. Why would form and subform have same tables (tblSchools, tblTeacher, tblJncTeacher) in their RecordSource? Why a subform to add values from the main form? I don't understand what you are trying to accomplish.

Each teacher or payment is tied to a booking via many to many. When schools go to the same booking they show in the submenu. So if 5 schools book to the same booking I need to show in that submenu if any have made payments. The top school is the school that has just made the payment (albeit I would like to hide that top one since it is the same as the one being currently edited). When you go to put in the payment I would expect that the submenu of that school to update with the new price.

The company might have 5 or more schools attend or book and cancel any one booking - either in a cluster at one school for a performance or at a theatre (divided between seats in that theatre). Hence I couldn't make multiple bookings for the same performance however I can add multiple schools to the one performance now.

I though it would be as simple as saying "this submenu" refreshes "after updating the price here". I don't quite understand how to affect submenus depending on what I want it to do.... I thought in VBA Me!SumenuControlorName.SumenuForm.Form!PriceTotal. refreshorrequery would work...? I've tried different combinations too with no affect.

It's nice to get an answer but to understand it is better (teach a man to fish).

[June7]

If I can't understand can't offer solution. Still not clear what is going on. You talk about submenu but did you mean subform?

Yes, forms and comboboxes can be requeried with the Requery method. I do it frequently. The syntax depends on where the code is executed.

Want to provide database? Follow instructions at bottom of my post. Identify objects involved.

[Ruegen]

If I can't understand can't offer solution. Still not clear what is going on. You talk about submenu but did you mean subform?

Yes, forms and comboboxes can be requeried with the Requery method. I do it frequently. The syntax depends on where the code is executed.

Want to provide database? Follow instructions at bottom of my post. Identify objects involved.

Sorry, morning here - I meant sub form not sub menu.

[June7]

Okay, but my previous post still applies.

[Ruegen]

Okay, but my previous post still applies.

um. I figured it out

It was

Me.Form.Refresh

It refreshes the main form which in turn refreshed the subform.