Simple select query imbedded into a form

[Wawa1979]

I don’t use access much so apologies if this is a simple question.

I have a form we will be using to up ‘client info’. This form updates a table. In this form there is client ID, client name and other info.



All clients are known already and are in table ‘tbl_clientinfo’

Now the prob. As we don’t want people enter client names differently, I want to populate in the form the client name, from ‘tbl_clientinfo’ using the client I’d that was populated in the form already.

I created a simple select query, and built the criteria to look to the client ID in the form, but this is not working and I can’t understand why?

Any help would be greatly appreciated

[pbaldy]

Use a combo box with that SQL as the row source, and set the limit to list property to yes.

[Wawa1979]

Use a combo box with that SQL as the row source, and set the limit to list property to yes.

Not sure this will solve

More simply as not being clear I think

In the form
Field 1 - “client ID”
Field 2 - populate the client name from table clientid based on looking up the corresponding ‘client name’ that is associated with the client ID populated in field 1. This field should populate once field 1 is populated

Clientid table simple has ‘client ID’ and ‘client name’ as the two only columns

[pbaldy]

http://www.baldyweb.com/Autofill.htm