Albert Kallal's Search Screen Example

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

Guest

http://www.members.shaw.ca/AlbertKallal/Search/index.html

I would like to implement a search mechanism like Mr. Kallal shows in his
examples. I would like to place fields at the top and I understand the
wildcard searches, etc. however I really do not know where to start to get
the subform to pop up in the bottom of his example on page 3 of his article.
Any assistance in getting me a little further is greatly appreciated. Thank
you professionals saviours.
 
I don't really have a posted example.

However, the code used in the example to "fill" the sub-form is simply
placed in the after update event of the top text box

"First Name to Search for" __________

The above is simply a un-bound text box called txtSearch

The code used to "fill" the grid with matches is

if isnull(me.txtSeach) = false then

strSql = "select * from tblCustomer " & _
" where LastName like '" & me.txtSearch & "*'"

me.MySubForm.Form.RecordSource = strSql

end if

So, the above will "fill" the sub-form full of matches....

now, the code behind the cute glasses button to "launch" or popup the
selected record
to edit in a form as the 3rd screen shot shows

docmd.OpenForm "frmCustomer",,,"id = " & me!id

So, there is not much code in this example at all. Here is some screen shots
of grids, and it will give you even more ideas....

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm
 
Back
Top