SubForms not displaying data

[gg80]

I am using a2007 and a2003 with a weird problem . Coding is with VBA.

I have a query sourced form with two subforms that are sourced to a table. The subforms are linked to the parent by an IDquote number. When update is clicked, the program imports a list of items from an excel file (excel is in same folder as the program) with unit prices to a table in the server. That table is the source for the subforms. ( I use two subs to so that the user can see all items without scrolling). The code for the transfer includes a requery and refresh command.

I have a weird problem. After an update, the subforms will show blank often, even though their source table is populated. If I create a copy with the tables and the program without a link, it runs fine.

Is there something special I should be do because of the server link? Or, am I playing with a corruption? Any help much appreciated.

[CJ_London]

after the update, do you requery the subforms?

[gg80]

Yes. The last item in code is form.requery. After receiving your reply, I added Form.SubformName.requery and still get blanks. Something strange; I hit the F9 recalc key when showing blank, then data appears.

[CJ_London]

I added Form.SubformName.requery

try just SubformName.requery

[gg80]

Works! Thanks much. I will never understand Access. It seems so inconsistent. This works fine without link, worked with link for long time. Now need this. Thanks again for solution and for quick replies. Much Much appreciated.

[CJ_London]

not really

you have the forms collection of all the open forms so to reference a form from outside of that form (e.g. another form, a query or report) you use forms!myformname

in a form you have 'me' which is a collection of all the form properties, sections and controls - so me.requery requeries the whole form or me.controlname.requery requeries a specific control. Me is the default so does not normally need to be used, but some consider to be good practice to use it. Sections and controls are also collections so you could use me.controls.controlname.requery if you wanted to do all that typing

subforms are slightly more complex - they are a control, so me.subformname, but they contain a form so to refer to a control on the subform from the main form is subformname.form.controlname. If you like think of subformname.form. being the way your refer to me. on a subform

and from subform to refer to a control on the mainform you use parent - e.g. parent.controlname

So just think about 'where you are' in relation to 'where is the data' and all should become clear!