Search form error

  • Thread starter Thread starter Steve Moody
  • Start date Start date
S

Steve Moody

Hello,

I have created a form that I am using to search for records in an address
database. I have coded it such that it will pull in a first name and last
name that the user enters and build a query based on that criteria. However,
I am experiencing a strange error. If the user enters invalid criteria such
that the query pulls up no records (i.e. a name that is not in the database)
all of the controls, labels, etc. on the form disappear. I'm left with a
blank form that I have to close and reload in order to get it back to
normal. Any ideas on why this may occur or how I can fix it?

By the way, I did find one work around. I created a record in the database
that has no information in it and set the query to default to that record.
That way the form appears to not be showing anything, but in reality it is
showing a blank record. The only problem here is, the was I currently have
it coded, if it does find records, it still appends the blank record to the
end of the query. So, say there are two records named "Joe." If the user
searches for Joe, the form will pull up 3 records -- two Joes and one blank.
That kind of bugs me and seems really flaky, but I can't figure out another
way around it.

Thanks!

Steve Moody
 
Put the search criteria in the form header area( I use
combo boxes) and the actual data in the detail section of
the form.

Jim/Chris
 
Back
Top