Upcoming deadline / Need help with requery

[PerkinsSlave]

We have a form called "frmScorecard" based on a table called "tblScorecardFinal." When the form loads, it's filtered to load to a specific record. When the form loads, it displays the data that's already been saved to the table. Ok so far.

Now, we have several text boxes with a similar problem - I'll just detail one here. We have a list box called "txtProdBucket2Calls." It's control source is bound to a corresponding field in the underlying table, "ProdBucket2Calls." Now, when the form is opened, there is no data in "ProdBucket2Calls" in the underlying table.

The control's rowsource is set to "SELECT qryBucket1C.Bucket1AHT FROM qryBucket1C; " That query works. The data displays on the form. However, when we close the form the data from the control does not pass & save to the underlying table.

I have experimented with DAO .Edit, "me.txtProdBucket2Calls.requery", and nothing seems to work.

Any suggestions?

 

[SydneyGeek]

You have 2 main options. If the textbox that you are synchronising to is a bound control (ie it gets its data from a field in a table / query) and you are synchronising with the same field in the subform, try the Parent/Child fields approach.
1. In Design view on the main form, click the subform ONCE and select the Properties icon in the toolbar. You should see the Link Parent /Child fields (or something liek that) property. Click the builder (...) to the right of the property and select the matching fields. That will do it.

If the field on the main form is unbound you will need some code.
MyTbx is the textbox that the subform synchronises to. It's on MyForm.
The Subform has an underlying query. The criteria row for the matching field should be [Forms]![Myform]![MyTbx]
Now,
You'll need to attach this to one or more events -- the On Load and On Current events of the main form, and the After Update event of the textbox whose data is being synchronised.
[MySubFormName].Form.Requery or [MySubformname].Requery

(can't remember the exact syntax, but one of the above).

HTH
Denis

 

[PerkinsSlave]

Hi Sydney,

Thanks for the reply. We ran into an additional problem dealing with nulls in some fields, so we completely changed our approach. Instead of querying for the data, we did all the updates programmatically through DAO. It works like a charm!

Thanks,
Paul