Create a list

[Propoflady]

I know this can be done because I have another access based
program(that the code is protected) that does it but I can't figure out
how.

I have a table with several fields, two of them are company and
lastname. I want a to open a form that has a box LastName/Company: and
when I start typing in that box all of the matches last name and
company populate the list - so for example I type in the box brow
and the list populates

Brown Construction
Brown James
Browst Inc

etc.

I posted this before and was told to use the criteria field with Like
but it doesnt' work in the other database I have I don't have to use
wildcards I just type and it comes up.

Thanks

PS I also got the reply combine Lastname and company into one field but
I know I don't have to do this because of the other database I have and
I don't want to do this

[Arno R]

Have you looked at http://www.allenbrowne.com/ser-32.html ?

Arno R

"Propoflady" <ch****@monticule.com> schreef in bericht news:11**********************@j33g2000cwa.googlegr oups.com...

I know this can be done because I have another access based
program(that the code is protected) that does it but I can't figure out
how.

I have a table with several fields, two of them are company and
lastname. I want a to open a form that has a box LastName/Company: and
when I start typing in that box all of the matches last name and
company populate the list - so for example I type in the box brow
and the list populates

Brown Construction
Brown James
Browst Inc

etc.

I posted this before and was told to use the criteria field with Like
but it doesnt' work in the other database I have I don't have to use
wildcards I just type and it comes up.

Thanks

PS I also got the reply combine Lastname and company into one field but
I know I don't have to do this because of the other database I have and
I don't want to do this

[Bob Quintal]

"Propoflady" <ch****@monticule.com> wrote in
news:11**********************@j33g2000cwa.googlegr oups.com:

I know this can be done because I have another access based
program(that the code is protected) that does it but I can't
figure out how.

I have a table with several fields, two of them are company
and lastname. I want a to open a form that has a box
LastName/Company: and when I start typing in that box all of
the matches last name and company populate the list - so for
example I type in the box brow and the list populates

Brown Construction
Brown James
Browst Inc

etc.

I posted this before and was told to use the criteria field
with Like but it doesnt' work in the other database I have I
don't have to use wildcards I just type and it comes up.
Since you can't see the code in the other form you can't see
that the programmer is probably using the Like operator, and
adding the wildcard in code after the entry but before passing
the criteria to the query. Do that and you'll have the operation
as you describe it.
Thanks

PS I also got the reply combine Lastname and company into one
field but I know I don't have to do this because of the other
database I have and I don't want to do this

What you again don't see is that the programmer of the other
database has probably taken the two separate fields and combined
them into a virtualized single one by coding a union query.
--
Bob Quintal

PA is y I've altered my email address.

[Propoflady]

Thank you !!!! the Union query works great but now I can't figure out
how to make it work in my combo box. I am using the wizard and trying
to create a combo box that finds a record on my form but I can't make
it work. Can you help.

[Bob Quintal]

"Propoflady" <ch****@monticule.com> wrote in
news:11**********************@i39g2000cwa.googlegr oups.com:

Thank you !!!! the Union query works great but now I can't
figure out how to make it work in my combo box. I am using
the wizard and trying to create a combo box that finds a
record on my form but I can't make it work. Can you help.

You'll have to forego the Wizard, (they are more like Lizards)
and code the combobox AfterUpdate event code manually.

Since I forget the field names you have, I cannot give the full
code, but something in the vein of

me.recordsetclone.findfirst "[lastname] = """ _
& me.combobox.value _
& """ OR [companyName = """ _
& me.combobox.value _
& """"

if NOT me.recordsetclone.nomatch then
me.bookmark = me.recordsetclone.bookmark
end if

--
Bob Quintal

PA is y I've altered my email address.