Query by Form doesnt query appended table

[Guest]

Hi guys,

I've appended an excel sheet to a Template Table "contacts" (contacts .mdb
Template). The query by form works only for new records that are manually
entered. However, when I set the form to query the table I originally
imported "import_table" and for example query last name, the appropriate
records show.

Here is the syntax I'm using for both queries...(with appropriate table
names)

For first name Like [forms]![QBF_Form]![WhatFName] & "*"

Do I have to do a make table query? If so, how does that work without a
unique ID? Thanks,

Mic

 

[Tanis]

The query by form does exactly that. It is used as a search facility
If you want to do anything else with the data then you have to creat
a query to do so, either an append query, if you want to add the dat
to an existing table or a make table query

 

[Guest]

Hi Tanis,

I do want to initially add a few hundred records, however all records I
append simply won't show up when using the query by form. I dont know,
perhaps the parameters are wrong for the append I created. Would an update
table work? I have been attempting that, but i seem to not be doing the
update query properly. Thanks in advance!

Mic