Update a form automatically

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J. Silva - 22 Sep 2005 20:27 GMT

Hello

I’m having some problems doing this:

-I have got the Form1 that has a field called “name of the company” that is
a Table/Query , where I can select the company I want and then open a Form2
that has got detailed information about that company (without close the Form1)
-My problem is when I introduce a new company in the Form2 (the only form
that I can introduce more record) and close it, the Form1 is still open but
didn’t update that new company in the field “name of the company”.

I would like to now the easiest way to update the Form1 when I close the
Form 2, without have to close the Form1 and open it again.

Thank at once the help.
Joana Silva.

Reply to this Message

Sprinks - 22 Sep 2005 21:21 GMT

Hi, J.

Simply requery the Form 1 combo box on returning. In the OnGotFocus event
of the combo box:

Me![YourComboBox].Requery

Sprinks

> Hello
>
[quoted text clipped - 12 lines]
> Thank at once the help.
> Joana Silva.

Reply to this Message

J. Silva - 23 Sep 2005 10:29 GMT

Thanks for the help but it still doen't work.

First I have a list box in the Form 1 that in the OnDblClick event has gor a
macro taht open Form 2 (its name is "listcompany"). When I put the expression
you said in In the OnGotFocus event I have the follow error:

"BD can't find the macro 'Me!Listcomany'
The macro (or its macro group doen't exist, or the macro is new but hasn't
been saved. Note that when you enter the macrogroup name. macroname syntax is
an argument, you must specify the name the macro's macro group was last saved
under".

Can you help me?

Thank you,
Joana Silva.

> Hi, J.
>
[quoted text clipped - 21 lines]
> > Thank at once the help.
> > Joana Silva.

Reply to this Message