Requery Combo box in subform from a third form

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

Guest

Hi,

checked the forum but couldn't find an answer to my question. Whitin a
subform I have a combo box to select a value (delivery note number). In case
the number isn't included within the list, a button opens a popup to insert
the value into the delivery note table. When this popupis closed through a
button, the new inserted number should be display in the combo box.
If I try to adress the combo box from the popup form with "
[..]![...]...Requery "I always receive the message "Object doesn't support
this operation" (well I translated from german).
Any helpful hint?
 
Tou didn't give as the path you used to refer to the combo, did you try this
path

Forms![MainFormName]![Sub FormNameWithinh the
MainForm].Form![ComboName].Requery
 
Yes, I used the proper path:
[Forms]![master_name].[sub_name.[Form]![combo].Requery
Ofer said:
Tou didn't give as the path you used to refer to the combo, did you try this
path

Forms![MainFormName]![Sub FormNameWithinh the
MainForm].Form![ComboName].Requery

--
\\// Live Long and Prosper \\//
BS"D


jokobe said:
Hi,

checked the forum but couldn't find an answer to my question. Whitin a
subform I have a combo box to select a value (delivery note number). In case
the number isn't included within the list, a button opens a popup to insert
the value into the delivery note table. When this popupis closed through a
button, the new inserted number should be display in the combo box.
If I try to adress the combo box from the popup form with "
[..]![...]...Requery "I always receive the message "Object doesn't support
this operation" (well I translated from german).
Any helpful hint?
Click to expand...
Click to expand...
 
When you open the form, open it as Dialog, and then run the requery.
the code will stop until you close the form, and the it will run the requery

DoCmd.OpenForm "FormName", , , , , acDialog
Forms![master_name].[sub_name].Form![combo].Requery

--
\\// Live Long and Prosper \\//
BS"D


jokobe said:
Yes, I used the proper path:
[Forms]![master_name].[sub_name.[Form]![combo].Requery
Ofer said:
Tou didn't give as the path you used to refer to the combo, did you try this
path

Forms![MainFormName]![Sub FormNameWithinh the
MainForm].Form![ComboName].Requery

--
\\// Live Long and Prosper \\//
BS"D


jokobe said:
Hi,

checked the forum but couldn't find an answer to my question. Whitin a
subform I have a combo box to select a value (delivery note number). In case
the number isn't included within the list, a button opens a popup to insert
the value into the delivery note table. When this popupis closed through a
button, the new inserted number should be display in the combo box.
If I try to adress the combo box from the popup form with "
[..]![...]...Requery "I always receive the message "Object doesn't support
this operation" (well I translated from german).
Any helpful hint?
Click to expand...
Click to expand...
Click to expand...
 
thx for your immediate help.

jokobe

Ofer said:
When you open the form, open it as Dialog, and then run the requery.
the code will stop until you close the form, and the it will run the requery

DoCmd.OpenForm "FormName", , , , , acDialog
Forms![master_name].[sub_name].Form![combo].Requery

--
\\// Live Long and Prosper \\//
BS"D


jokobe said:
Yes, I used the proper path:
[Forms]![master_name].[sub_name.[Form]![combo].Requery
Ofer said:
Tou didn't give as the path you used to refer to the combo, did you try this
path

Forms![MainFormName]![Sub FormNameWithinh the
MainForm].Form![ComboName].Requery

--
\\// Live Long and Prosper \\//
BS"D


:

Hi,

checked the forum but couldn't find an answer to my question. Whitin a
subform I have a combo box to select a value (delivery note number). In case
the number isn't included within the list, a button opens a popup to insert
the value into the delivery note table. When this popupis closed through a
button, the new inserted number should be display in the combo box.
If I try to adress the combo box from the popup form with "
[..]![...]...Requery "I always receive the message "Object doesn't support
this operation" (well I translated from german).
Any helpful hint?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top