Here is the total code.
VB Code:
  1. Dim strGenre As String
  2.     Dim strPlatform As String
  3.     Dim strFilter As String
  4.     'if the value in this combo box is null, then show all records
  5.     If IsNull(Me.cboGenre.Value) Then
  6.         strGenre = "Like '*'"
  7.     Else
  8.         strGenre = "='" & Me.cboGenre.Value & "'"
  9.     End If
  10.      'if the value in this combo box is null, then show all records
  11.     If IsNull(Me.cboPlatform.Value) Then
  12.         strPlatform = "Like '*'"
  13.     Else
  14.         strPlatform = "='" & Me.cboPlatform.Value & "'"
  15.     End If
  16.     'combining criteria to form a WHERE clause
  17. strFilter = "[Genre] " & strGenre & " AND [Platform] " & strPlatform
  18.    
  19.     With Reports![rptTopRented]
  20.          .Filter = strFilter
  21.          .FilterOn = True
  22.     End With


The bit I want to change to allow the numerical data is:

VB Code:
  1. Else
  2.         strPlatform = "=' " & Me.cboPlatform.Value & " ' "
  3.     End If

The combo box names 'cboPlatform' is a list of Number ID's. And since currently its interperated as text, I've been told to maybe adjust or take out the qualifiers (I dont know what a qualifier is) in that bit of code to cater for numerical data.

Also, I have a code, where, I want select a field (which has numbers too) and simply show ONLY the HIGHLEST value. What do I need to add to this code in order to do this?

VB Code:
  1. strFilter = "[Genre] " & strGenre & " AND [Platform] " & strPlatform

help ASAP appreciated. Project due tommorro!