Auto fill as user types in combo box microsoft access 2007

linbayzak,

Sounds simple enough.

If not, then you will have to be a bit clearer and explain exactly what you mean when you say:
  "fill the field area"

Here is a sample

JeffCoachman
Access-EEQ23854284AutoExpandAuto.mdb

Hi Jeff,
This is really strange, I have all the same property settings as you with the exception of:
**field is bound
**Row Source gives name of query instead of select statement.
I put my info into your db  and attached it so you can see it. Thanks.

Laura
Access-EEQ23854284AutoExpandAuto.mdb

Your sample needs the linked tables.

Please submit a sample I can just open and see the issue.

Ok, here are the linked tables, they are in a separate db.

Thanks :-)
Laura
Linked-Tables-DB1.mdb

OK, so I opened the database

All the dropdown appear to work fine.

So what's the problem?

Drop downs work fine, but my client wants to type in put and Putnam come up in the counties, or me and Melissa Taylor come up in the staff members.  She wants to use her keyboard exclusively or as much as possible.  The form in there that Jeff Coachman developed works that way, but mine don't and they have the same properties.  Any idea what is going on.  My combo boxes have a query as recordsource, is that the difference?

Thanks,
Laura

And also, Jeff's combo box is unbound.  Not sure if this might make a difference.

Thanks,
Laura :-)

Nope, I found it, the bound column was causing the issue, I had the second column bound because I want to save it in the db as the name not the id, but this is what was causing the problem.

I wonder if there is any way around that.

Laura

Thanks Jeff.  you are right.  I don't even know what I was thinking.  Thanks for your help, I used your form example to test mine and eventually came up with the solution.  Have a great day :-)

Laura

;-)