Automatically filling out a form

[thorpef1]

Hey guys.
First post, hopefully you can help me.



I have a table full of data, and now when i go into the form to add a new row i want it to automatically see if the primary key is there and fill in the form.

So, when i type in the account number in the field box, if there is already a row with that account number, i would like it to realise that and automatically fill out all of the other fields in the form.
Either automatically or via a button.

Im not a big coder, so if someone had the code or a template that would be great.



Thanks heaps

[RuralGuy]

Have you looked at the features of the ComboBox wizard?

[thorpef1]

RuralGuy.

There are thousands of records so a combo box wouldnt be the most effective way

[RuralGuy]

Setting AutoExpand and LimitToList to YES would speed up the entire process. Use the NotInList event to move to a new record. You might be surprised how slick this would work. Select #3 from the wizard.

[thorpef1]

Thanks for that RG.

Will give that a go and hopefully it works fine

[RuralGuy]

Post back to this thread if it does not work as advertised or you would like some additional assistance.

[thorpef1]

Had a bit of a play around and got it working just fine.

Thanks heaps RuralGuy

[RuralGuy]

That's great! Are you ready to follow the link in my sig to mark this thread as Solved?

[thorpef1]

Hey RG, while i have you, can you also help me out with another quick thing:

I want to make a form so down the bottom it shows record x of y.
I know it already has it down the bottom but i want it a bit bigger in a label, kind of what you can put in the footer in word.

Cheers

[RuralGuy]

See if you can't borrow some code from Stephan Lebans' Nav Buttons.

[thorpef1]

Hmmm.
Blocked at work.
I might have a look at home and see if i can get something.
If not i will be back here tomorrow.

Thanks RG

[RuralGuy]

I'll keep an eye out.