Subforms update

[himal]

Hi
I have a main form and two subforms (tabular) and I have a combo box on the main form and would like to update the data in two subforms based on selection on combo. I tried requery on main form for example

Me.[subform name].requery

this won't update anything on my subform. I tried this on "onactivate" event.
tables are customer info (main form), jobinfo (subform), statusinfo (subform).

Thanks in Advance

 

[Oldsoftboss]

Try this...

http://www.access-programmers.co.uk/forums/showthread.php?t=99132&highlight=subform+update

Dave

 

[himal]

Thanks dave, i'll try that

Is there any good reference material for form events properties other than help file.

 

[Oldsoftboss]

I use the info here...

http://www.access-programmers.co.uk/forums/showthread.php?t=113860

Dave

 

[himal]

could not make it work

I've attached the file.

what i'm trying to achieve is by selecting the name from combo box i would like to update the subforms

Any help appreciated

 

[ansentry]

Here is your db back, what I hope you wanted was a combo in the header to find the record. I also fixed the TypeID in the second sub form.

 

[Oldsoftboss]

Or with a listbox....

PS: Watch your naming conventions in your tables. Never call a field "Name" etc. Always preface it with "custname" or "compname"

Once you start to write code, Name can refer to Access objects as well, and confusion will reign.

Search threads here for naming conventions.

Dave