Requery on List

[Guest]

I have tried all ways of trying to requery and I always fail
I have a drop down list in My "Order Form" - if entering a name that does
not exist then the "Not on List" event loads a PopUP form and I enter the new
Name and Address and other information - After update the PopupForm is closed
and I return to the Order Form - Whn I return is where I want the Requery but
I do not know where to put it and on which Event or how to word it - If you
try and use Ctl+F9 it starts up the PopUp Form again as there is an entry in
the field - if I delete the name that I have typed in then Calc+F9 works - I
want the system to do it by itself - is there a way

Tks

 

[Guest]

When you close the Popup form, on the unload event, write
Forms![Order Form]![ListBoxname].requery

If you open the popup form from few places, then on the open form command
pass an openargs to knew from which form you came from.
If you need help with that then tell us.

 

[Guest]

In the "Customers Not on List" form i have the following : Form Properties
After Update a Macro that closes the forn
In On Unload I have the following as an event "Forms![Order
Details]![CustomierID].Requety"
The new Customer is saved and form closed
Ten an error message comes up "Run-Time Error '2118'
You mustr save the current field before you run the Requery action
When you click Debug the "form?? is highlighted in yellow"

When you close the Popup form, on the unload event, write
Forms![Order Form]![ListBoxname].requery

If you open the popup form from few places, then on the open form command
pass an openargs to knew from which form you came from.
If you need help with that then tell us.

I have tried all ways of trying to requery and I always fail
I have a drop down list in My "Order Form" - if entering a name that does
not exist then the "Not on List" event loads a PopUP form and I enter the new
Name and Address and other information - After update the PopupForm is closed
and I return to the Order Form - Whn I return is where I want the Requery but
I do not know where to put it and on which Event or how to word it - If you
try and use Ctl+F9 it starts up the PopUp Form again as there is an entry in
the field - if I delete the name that I have typed in then Calc+F9 works - I
want the system to do it by itself - is there a way

Tks

 

[Guest]

On the not on list event, where you open the popup form, try and delete first
the value.
me.CustomierID = null
docmd.openform ....

See if it will let you requery now.
Forms![Order Details]![CustomierID].Requery

In the "Customers Not on List" form i have the following : Form Properties
After Update a Macro that closes the forn
In On Unload I have the following as an event "Forms![Order
Details]![CustomierID].Requety"
The new Customer is saved and form closed
Ten an error message comes up "Run-Time Error '2118'
You mustr save the current field before you run the Requery action
When you click Debug the "form?? is highlighted in yellow"

When you close the Popup form, on the unload event, write
Forms![Order Form]![ListBoxname].requery

If you open the popup form from few places, then on the open form command
pass an openargs to knew from which form you came from.
If you need help with that then tell us.

I have tried all ways of trying to requery and I always fail
I have a drop down list in My "Order Form" - if entering a name that does
not exist then the "Not on List" event loads a PopUP form and I enter the new
Name and Address and other information - After update the PopupForm is closed
and I return to the Order Form - Whn I return is where I want the Requery but
I do not know where to put it and on which Event or how to word it - If you
try and use Ctl+F9 it starts up the PopUp Form again as there is an entry in
the field - if I delete the name that I have typed in then Calc+F9 works - I
want the system to do it by itself - is there a way

Tks

 

[Guest]

Only just got back to it - Had to stop last night and Watch the Tour and
Lance Armstrong

Thank you very much - I have learned a lot and your suggestions all worked

I have never combined Expressions and macros before but it sure made thing a
lot easier

On the not on list event, where you open the popup form, try and delete first
the value.
me.CustomierID = null
docmd.openform ....

See if it will let you requery now.
Forms![Order Details]![CustomierID].Requery

In the "Customers Not on List" form i have the following : Form Properties
After Update a Macro that closes the forn
In On Unload I have the following as an event "Forms![Order
Details]![CustomierID].Requety"
The new Customer is saved and form closed
Ten an error message comes up "Run-Time Error '2118'
You mustr save the current field before you run the Requery action
When you click Debug the "form?? is highlighted in yellow"

When you close the Popup form, on the unload event, write
Forms![Order Form]![ListBoxname].requery

If you open the popup form from few places, then on the open form command
pass an openargs to knew from which form you came from.
If you need help with that then tell us.

:

I have tried all ways of trying to requery and I always fail
I have a drop down list in My "Order Form" - if entering a name that does
not exist then the "Not on List" event loads a PopUP form and I enter the new
Name and Address and other information - After update the PopupForm is closed
and I return to the Order Form - Whn I return is where I want the Requery but
I do not know where to put it and on which Event or how to word it - If you
try and use Ctl+F9 it starts up the PopUp Form again as there is an entry in
the field - if I delete the name that I have typed in then Calc+F9 works - I
want the system to do it by itself - is there a way

Tks

 

[Guest]

Happy I could help, Good luck with your project

Only just got back to it - Had to stop last night and Watch the Tour and
Lance Armstrong

Thank you very much - I have learned a lot and your suggestions all worked

I have never combined Expressions and macros before but it sure made thing a
lot easier

On the not on list event, where you open the popup form, try and delete first
the value.
me.CustomierID = null
docmd.openform ....

See if it will let you requery now.
Forms![Order Details]![CustomierID].Requery

In the "Customers Not on List" form i have the following : Form Properties
After Update a Macro that closes the forn
In On Unload I have the following as an event "Forms![Order
Details]![CustomierID].Requety"
The new Customer is saved and form closed
Ten an error message comes up "Run-Time Error '2118'
You mustr save the current field before you run the Requery action
When you click Debug the "form?? is highlighted in yellow"


:

When you close the Popup form, on the unload event, write
Forms![Order Form]![ListBoxname].requery

If you open the popup form from few places, then on the open form command
pass an openargs to knew from which form you came from.
If you need help with that then tell us.

:

I have tried all ways of trying to requery and I always fail
I have a drop down list in My "Order Form" - if entering a name that does
not exist then the "Not on List" event loads a PopUP form and I enter the new
Name and Address and other information - After update the PopupForm is closed
and I return to the Order Form - Whn I return is where I want the Requery but
I do not know where to put it and on which Event or how to word it - If you
try and use Ctl+F9 it starts up the PopUp Form again as there is an entry in
the field - if I delete the name that I have typed in then Calc+F9 works - I
want the system to do it by itself - is there a way

Tks