Event Handling and Table/Query Filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a double-click event on a text box in my form (Access 2003). I want
the event to open a TABLE and then filter the table for the user based on the
criteria in code, please how do I do this programmatically?

How would I do the same thing with the event opening a Query?

thank you.
 
Bret said:
I have a double-click event on a text box in my form (Access 2003). I want
the event to open a TABLE and then filter the table for the user based on
the
criteria in code, please how do I do this programmatically?

How would I do the same thing with the event opening a Query?

thank you.
Click to expand...

I wouldn't do either. There's really no need to open a table directly, and
lots of reasons not to. Instead, I would create a form based on the table or
query, then open and filter that:

DoCmd.OpenForm "form name",,,"[my field]=" & Me.txtTextBox.Value


Carl Rapson
 
Back
Top