Hi guys,
I've found this bit of code that I'd quite like to use but rather than having the values show up in a listbox, I'd like them to be selected from a combobox.
Can someone provide assistance please?
Thanks,
Dom
Please Login or Register to view this content.
Last edited by dcompagnone; 08-12-2010 at 04:16 PM.
Change the listbox references to point at your combobox and use the Exit event (or Change if you prefer) rather than the click event.
Remember what the dormouse said
Feed your head
I have no idea why it didn't work when I tried that the first time but it's working now, so thank you.
It's thrown up a new challenge though:
When I click 'Amend' on my form, I'm getting a type-mismatch on the ' .Cells(n, 1).Value = one' line.
Any clues?
Please Login or Register to view this content.
What is the value of 'one' at the time?
Probably easier if I just attach the file as it's only a tiny tester at the moment.
I can't work out what's going wrong here.
The problem is on the 'Amend' Button
The ComboBox drops down and works fine but I can't get past this type mismatch problem. Been looking at it for so long now, I'm blind to it!!
Take a look!
Dom
Your problem is that in this line:
there is no match (you are searching for a text representation of a number in a column of actual numbers) so n is actually an error value, which you can't then use as a row number. You need to use:Please Login or Register to view this content.
Please Login or Register to view this content.
that was actually my error. colum c, even in the new database will be a text value.
I'm still getting errors though. nothing updates now - clicking 'edit' on the form just converts the date format!
Works fine for me after making the adjustment I mentioned.
or see the attachment:
romper, you have been a stomper.
Thank you for your help. I had deleted an extra line when I made the change as you suggested.
Solved.
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks