form search how

[Jen0dorf]

Hi

not sure what direction to go in with this issue

I have two tables in a relationship

If I create a query

[CODE]]SELECT tblDeceased.Mlink, tblDeceased.Plot, tblDeceased.GraveNo, tblDeceased.Forenames, tblDeceased.Surname, tblDeceased.Inscription, tblMemorial.Mlink, tblMemorial.Inscription
FROM tblMemorial INNER JOIN (tblDeceased INNER JOIN tblJoin ON tblDeceased.GraveID = tblJoin.fkGraveID) ON tblMemorial.MemorialID = tblJoin.fkMemorialId;[/CODE


then as I would expect the query shows all records

It's from this point on I get confused

I want to create an editable table from that query

where all the records are shown in datasheet view



And I want to be able to filter/search by surname or Mlink

can't seem to be able to figure out how to do it.

Appreciate any hints

thanks

Ian

[ranman256]

1. this joined query MAY NOT allow you to edit. Some do. It depends on your tables.

2. make a form, for continuous records on your query. (use the wizard)
in the form header, place a text box, say textBox123
in the event property, AFTERUPDATE event, put this code...

if isNull(textBox123) then
   me.filterOn = false
else
   me.filter = "[surname]='" & textBox123 & "'"
   me.filterOn = true
endif

that is for exact matches. If you want near match..
me.filter = "[surname] like '" & textBox123 & "*'"

[vicsaccess]

There's probably several ways to search a form, have you tried using the combobox wizard? or maybe a simpler version of http://allenbrowne.com/ser-62.html

[Jen0dorf]

Hi

thanks one and all

project for tomorrow

cheers

Ian