i have a textbox SearchTime, how can i search time that is inputted in the subform?
for example
i have a record ComputerName=PC1 , TimeStart1= 7:00am and TimeEnd1=10:00am
what if i input in the SearchTime 8:00am and the PC1 will appear in the subform. it is possible to do in access?

Thanks in Advance Have a nice Day (IMG:style_emoticons/default/smile.gif)

Welcome to UtterAccess.

Your question is just a bit vague, but we do have enough information to give you a general answer.

Let's say you have this form and on this form there is a control where you can enter a time, such as 8:00AM. Now, the trick is how you want the value of PC1 to "appear" in the form. That's the vague part. We can't tell you that because we don't really know what that might mean.

What you can do is use a criteria like this to filter all records that qualify.

" WHERE Forms!frmYourFormNameGoesHere.sfrmYourSubformNameGoesHere.Form.txtYourTimeValueCon
trolNameGoesHere Between TimeStart1 and TimeEnd1"

Whether you use that in a query (most likely) or somewhere else (less likely) is not clear yet. WHat goal are you trying to achieve?