belated followup

[junkmale]

provided ' solution ' is AIRWARE ...

lol... support your AIRWARE tho... works more often than not...

no, i've not tried that particular line, but upon trying it, i get the message after i close the author form(supposedly when they carry out this command)...

"Object doesn't support this property or method."

first time i got this message before. what does it mean?

btw, it didn't get requeried into the dropdown also.

 

[namliam]

Why do you "On Close" Want to requery a combo box on the sub form?? Dont seem logical....


Proper line:
Me.YourSubform.Form.Controls("YourCombo").Requery

If that fails you might try something like
Forms("Yourform").Form.controls("").requery
Forms("Yourform").controls("").requery
etc

alternative solutions again airware... "Proper line" was tested...

Regards

 

[junkmale]

Why do you "On Close" Want to requery a combo box on the sub form?? Dont seem logical....

Proper line:
Me.YourSubform.Form.Controls("YourCombo").Requery

On closing a form for "New Author", i need to requery the combobox in the original subform "AuthorBook", so that i can now select the new author from a dropdown???

yeah, the proper line works!

thanks again!