Robot Function for Click Event

[Guest]

Hi,

I've been working on this problem for days and I'm in a "burned down" state.
My VB ability leaves a lot to be desired so I could really use some help.

As is condition:
I have a bound List Box with the Row Source set to Query a specific piece of
information. I have a bound Text Box that will display the detail of the
second column of the Bound List Box.

Both the List and the Text boxes are bound to the same Table through the
same Query.

I have an On Click Event for the List Box that looks like this:

Me.EO_Compliance_Description_Text_One.Value =
Me!EO_Sub_Category_List_One.Column(1)

The Text Field on the Form updates as expected when the List Box is Clicked.

The Form writes back to the appropriate fields in the Table but the open
Query/Table display will not update until it is closed and reopened.

I would like to do two things:
Have the bound Text Box to automatically fill without having User to Click
the List Box – robot or simulated click? Second, how do I get an open Query
or Table to update when it is open?

Many thanks,
Larry

 

[Guest]

I think you need to do a on the Requery the Query/Table. For the other part,
without a click or some other input from the User, how do you know when you
have selected the row you want?
Let me know how you want this to work, it may be solvalbe.