Compare

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

I am working on creating a QBF to search my database. I have the form set up
and the query that I want to use(having a hard time doing this). After I
finally get this create I was wondering if it is possible to then select the
record from the query and go to the form with all the information about that
record(since the query does not contain all the information). I would also
like to know if it is possible to somehow allow the user to select multiple
filtered records to compare then side by side(what I am thinking of is like
what is done when you want to compare cell phones or other products). I also
would like to know if on my search form if I can have a field that may not
match any of the filtered records but they still want to see the
results(example they filter by city, state, name but they also want to see an
address other wise would not match city, state, name so it would be like an
or option).

Thanks,

Austin J. Hagen
 
to compare side by side:
you can open multiple instances of the same form (see access help how to do
this) and show different records in each instance, you can also position
forms one below other using docmd.move.
of course, this will work if you have a big screen and small form...
 
Would this allow me to have a field called compare(on the filtered results)
where a user could check the ones they want to compare?
 
Back
Top