help with user form and combo box

[TechRetard]

Ok, I am beginning a project to add the option to edit/add data through a user form.

My first two problems are:
(1) when the form comes up the combo box isn't populated...I can hit a button (in my case the Cancel Button) to initialize the form, but how so i make it so it is initialized when it initially shows
(2) when I select the title from the combo box, only 1 text box is populating

Thanks for lookin at this with me

[royUK]

For a start, you haven't used the correct procedures for the form. In the VB Editor select the form & use the right hand drop down to select the procedures

[royUK]

Try replacing your code with this, not sure why you jave most of that code

Please Login or Register  to view this content.

[TechRetard]

not sure why you jave most of that code

story of my life


Thanks I'll give that a whirl

And thanks for the heads up on the procedures ---

Now im going to try to make it learn whether to update or add...might see me in a few hours

(vba is new to me, i'm used to C#.net..same thought process diff syntax)

[TechRetard]

I think I got it....

Please Login or Register  to view this content.

[royUK]

So what's wrong with the code that i posted? It posts to the next empty row much more efficiently than your code

[TechRetard]

much more efficiently than your code

...that is your code

The code in the middle that I added updates the record if it already exists

[royUK]

If you want to include amending data in the OK button, use the ListIndex to get the Row, avoiding looping

Please Login or Register  to view this content.