View Full Version : Problem with Query search


Faray
08-02-2009, 05:49 PM
Alright, maybe someone can give me a hand here. I'm made a search query, where the user can enter either one or two items on a form. If they do, it comes ups with the field that they searched for. This works great, except it also brings up one empty field with no data what-so-ever.

The form you just can either input itema or itemb.

The query uses [forms]![Form1].[itema] for the first item and
for the second item on the second line [forms]![Form1].[itemb]

Any help would be appreciated.

neileg
08-03-2009, 05:08 AM
If you are viewing the data in query view, there will always be a blank record at the bottom of the query ready for a new entry. Is that whay you mean?

Faray
08-03-2009, 06:40 AM
If you are viewing the data in query view, there will always be a blank record at the bottom of the query ready for a new entry. Is that whay you mean?

It's not in query mode, it's in the form where this shows up. Though I take it that extra blank record is what is causing the problem though so if there is a way to get rid of that I think it would fix what I am having an issue with.

neileg
08-05-2009, 12:38 AM
If you change the form properties Allow Additions to no, this will remove the blank record. It will also prevent you adding records, however.