Update a form automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi, J.

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

Me![YourComboBox].Requery

Sprinks
 
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.

"Sprinks" escreveu:
Hi, J.

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

Me![YourComboBox].Requery

Sprinks

J. Silva said:
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.
Click to expand...
Click to expand...
 
Back
Top