Problem with Query search

[Faray]

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]

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]

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]

If you change the form properties Allow Additions to no, this will remove the blank record. It will also prevent you adding records, however.