Macro the Hidden Art

[BaBaBo]

I have looked at Access 2003 and Access 2003 the Bible and crap is there very
little about Macros.

I have two forms, a form and a sub form.

There is a combobox in the subform that looks up the value of a combobox in
the main form to complete it's function.

So I get the problem that when I open the main form, the subform combobox
jumps the gun. The subform combobox wants to know the value in the main form
combobox box, is so that it can run it's function.

To solve this do I have tried to set the query as a macro and put the macro
in the "on click" property of the combo box in the subform.

This has been elss than sucessfull.

In addition if I do add the query as macro in the "On click" property of the
combobox, I do not know what to put in the "Row Source Type" and "Row Souce
Properties" for the combo box.

Finally am I reachhing to far with querys and marcros. Should I be using VBA
for a combo box in a sub form dependent on a combobox value in the main form
to run it's process.

Thanks in advance for all your help.

I am going to post this on the Query Board as well as "Subform Querie
dependednt on main form combobox"

 

[Gary Brown]

Have you tried using the 'Not In List' property event?

You could tell the combobox to be NULL with something like...

Private Sub Combo0_NotInList(NewData As String, Response As Integer)
Me.Combo0.Value = Null
End Sub