View Single Post
  #6  
Old April 23rd, 2010, 11:17 PM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Requerying data on differnet tab

You might not be doing anything wrong ... remember, Cosmic Rays Happen...g

Jeff
"szag via AccessMonster.com" u2885@uwe wrote in message
news:a6f95d5f6cbdc@uwe...
Thanks. Jeff - does this help:

The main form is F_Jobs

There is a tab control in this main form

I am in F_AddJob form (tab page 1)
I update cboxJobs control (in F_AddJob form)

I want F_JobsQuote (form on tab page 2) to requery (using the result of
cboxJobs in an underlying query of F_JobsQuotes)

The code included has worked before - just don't know what I am doing
wrong.

Jeff Boyce wrote:
I'm confused ...

What is the name of the form you wish to requery?

(by the way, if this code is, as it appears, behind a control on a form,
the
Access 'shortcut' for saying "the form I'm in right now" is:

Me.Requery

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

Get an Object doesn't support this property or method error...

[quoted text clipped - 15 lines]
this F_JobsQuote form each time a different selection is made on
cboxJobs.


--
Message posted via http://www.accessmonster.com