Search results

Quite simply, I have a form with a sub-form showing data in a datasheet view. On the main form I have a button. On pressing this button I want to do two things 1) check that a row has been selected in the datasheet view 2) if a row has been selected, I wish to open a new form and populate the...

Hi, I recently came across this problem. Using a current form ("Me") and a subform containing the data to be filtered ("Form_Name"), the following can be used to filter for records with the "Number" field set to a variable "Num". Me.Form_Name.Form.FilterBy = "Number = " & Num...