How refresh form with linked table data

[lumolux@gmail.com]

Hi guys,

I´m using a access form to manipulate data with a linked excel table with many complicated formulas.With the limitations of access 2003, about the law, I´m using a code to copy and paste excel rows at the linked plan and thus creating a brand new row and obviously a new record, but I can´t see the new register on the form!!! What can I do?
I´ve tried a code similar to this "Forms.[myform].requery", but after that the form shows the last used record but the new one it´s just only on the linked excel plan.

Thanks,

luiz.

 

[Guus2005]

Using an Excel table as a datasource gives a you a very static table. refreshing the forms doesn't work because it is not the form that neede to be refreshed but the link between Excel and Access. Dropping the link and reconnecting to the spreadsheet is a solution.

A little farfetched i think and there probably is a better solution but this reply brings you back at the top of the list and perhaps someone else has a better answer.

Good luck!

 

[lumolux@gmail.com]

Good, but how can I do it by code? Remember I´m at the form, there´s a new register in the Excel linked plan then I need a short way to see that. It´s too complicated minimize the form drop down the form , relink, open form... .One thing I´ve remembered: if I close the form after that open it again, manually, the new register just apears in the form, but if make a button with a macro under that to close and open the form it does not work.
Anyway Guus thank you for your reply.

Luiz.

 

[Guus2005]

perhaps you could try me.requery instead of me.refresh. That's in VBA code , not a macro.

HTH

 

[lumolux@gmail.com]

Yes, I´ve already tried a code similar to that one you suggest, it´s at the top post: "Forms.[myform].requery".It didn´t work.