combo box item data property

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

Guest

Hey, I am having a problem with my combo box. I have a subform that when adds
a new entry into a table upon return from the subform i would like to go to
the new entry so i have refreshed the query and now have the following code
in the subform:

Form_FrmIP.Refresh
Form_FrmIP.Requery
Form_FrmIP.Combo19.ItemData (Form_FrmIP.Combo19.ListCount - 1)
DoCmd.Close

but when running it i get a message box that says Invalid Use of Property
and highlights ItemData. Am I doing something wrong that I'm missing?
 
Try:

Form_FrmIP.Combo19 = Form_FrmIP.Combo19.ItemData
(Form_FrmIP.Combo19.ListCount - 1)
 
Thanks that did the trick(though i had to move it to after the refresh and
requery. only problem now is i thought the text boxes that updated when i
made a selection normaly would also update like i had clicked on the
selection. oh well back to the drawing board. thanks again
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

updating text boxes based on combo box value 1
Combo box default 7
Basing one combo box on another 2
Requery Combo box in subform. 0
Updating tables when you input new data 0
Subform Data Entry Setting 0
problem with mulit-column value list combo box 2
How to update a combo box with a query 4

Back
Top