How to write a Search Macro in ms access (1 Viewer)

i am using Issues web database,
i have created my custom table , forms.
my custom table contains one column namely "SubmitedDate".
My requirment is in the form i have 2 textboxes "Startdate" and "EndDate"
If the SubmittedDate lies between "StartDate" & "EndDate" then display the result in Datasheet of that form

Could you please tell me how to write the macro logic to approach this

Thanks in advance,
Rasna.