cute pictures of Anna Kournikova

[clueless2003]

another stupid question (was: cute pictures of Anna Kournikova)

Oh...sorry, not here--but I got a bunch of you to look!

Here's my problem: I've created a form within a database that is basically going to serve as a look-up. I want to be able to have the user input an account # and have the output be all of the related data in about 10 different fields. For this, I'm using a combo box. Simple enough, right? But, while I want the data to populate the other fields immediately after the user inputs the account # and presses Enter, I'm seeing the cursor bounce to the next field...and then the field after that...and the one after that.... And, in the current iteration, these fields are not even populating!

Why, why, why, why.....WHY!?!

 

[AncientOne]

How are you trying to do it?

 

[clueless2003]

Ancient One,

The form is drawing from one table. There are 20-some fields in the table but, for purposes of this form, I'm only interested in 14 of them. When the user inputs to the first field, account #, the rest of the fields should populate after the user hits Enter. But...for some reason this isn't happening. Is it vital that the table and the form has to list the fields in the same order? I can't imagine so, but I'm puzzled.

 

[WayneRyan]

Clueless,

Look at some of the threads here ...

http://www.access-programmers.co.uk...d=173561&sortby=lastpost&sortorder=descending

Wayne