Selecting multiple records from a continuous form

[mozgheib]

Hello,

I have a bound form to a linked table. The table has got several rows. As part of each row structure there is a checkbox.

I would like to know how to select specific records from the form based on certain criteria?

It seems like I need to loop around something. Can u please tell me what to do I have no Clue.


Thanks.

 

[PHV]

Have you tried to play with the Filter and FilterOn properties of the form ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Zion7]

Easiest way for a single criterion is to, highlight or enter the field you want filtered, when the field record is correct & hit the "filter by selection" icon, on the toolbar. (form with lightning bolt through it).
eg; if you have a field called "txtCity" 7 you want to filter all records where txtCity = Montréal, scroll till any record shows Montréal in txtCity, enter cursor in txtCity, hit "filter by selection icon.

Secondly;
RecordSource property of form..
SQL eg;
Dim SQL as String

SQL = _
"SELECT tblCountries.* " & _ 'shows all fields
"FROM tblCountries " & _
"WHERE tblCountries.txtCity = ""Montréal"";"

Forms!frmCountries.RecourdSource = SQL

for the filter property it would be like..
Me.Filter = "txtCity = ""Montréal"""
Me.Filter.On = True

Hope this offers some direction?
Good Luck!