get name where number =

[revnice]

I'm clearly not understanding where I'm supposed to put what for each box and I've been going in circles on this for days - any chance you can post a picture?

[RuralGuy]

How about using the FORM wizard to create a form for you first?

[revnice]

A mighty offer!

Sure, by all means create the form for me. I've posted my one table containing one row, hope you're not intimidated by a 5k file

If you can make Field 2 in a form auto-populate based on Field 1, you'll be on my Christmas card list for at least a year!

I'm using Access 2007.

Thanks - rev

[RuralGuy]

Access has a Form wizard. I was suggesting you use it.

[revnice]

I have. I don't know how many times now.

The wizard only creates a form based on the columns you choose. It doesn't provide the auto-populate functionality I'm looking for - even the ID lookup has to be done separately.

The wizard saves you choosing the fields from the Field List, that's about all.

If you know how, I'd really appreciate you throwing it together and posting it. I only need to see it once, I can add fields and functionality myself after that.

[RuralGuy]

After the FORM wizard creates the form with the fields you want then use the ComboBox wizard with Option #3 to add *another* ComboBox that will do the Lookup for you.

[revnice]

Yep, I've got that working. The lookup shows me ID, Name1 and Name2.

Now, when I choose the ID, how do I make the Name fields auto-populate? They contain Name1 and Name2 as the RecordSource in their respective Property sheets but nothing changes.

[RuralGuy]

Post your db and I'll look at it. You should have selected Option #3 when defining the cbo and when complete it will move the form to the record you chose.

[revnice]

Contacts.zip is posted above. It's only one table with one row.

Moving the form to the selected record was going to be my second question. The first is how to auto-populate the cusinfo in the form based on the entered ID.

Thanks for taking a look!

[RuralGuy]

What you posted was an Excel spread sheet with one row filled out, not an Access db. I want to see the Access db that you have been working on.

[revnice]

That's it. That's the whole db. There's nothing else and I didn't know how to export it as a .accdb file. If you Import it you'll have everything I have.

My plan was to achieve something small and build on it but I never managed to achieve anything. I got stuck on the very first task.

[revnice]

RuralGuy!

I got it working, thanks for all your help on this.

I'll be back

rev