keyongtech


  keyongtech > access.* > access.main > 05/2006

 #1  
05-05-06, 09:00 PM
Barkster
I have a form with a couple of unbound fields that I want to use to
filter a subform/dataview on it by the value you type in the fields.
The query on the dataview uses Like
"*"+[Forms]![SearchForm]![Company]+"*" and I have on the company field
a keyup event to requery the subform below as
Forms!SearchForm!Datagrid.Requery. The subform is actually called
ContactSub but is named datagrid on the Main form. When I run the form
it will filter onload with whatever the previous value was but I cannot
get it to requery the dataview on keyup. Any ideas on what I'm doing
wrong. Thanks
 #2  
05-05-06, 10:50 PM
Barkster
I'm getting closer to tracking it down, on load the value is set for
the text field then as you type a new value in it the value remains the
old value. The textbox value isn't changing as you type. Onload it is
"Home" and if I erase and type a new value it is always "Home" when I
debug the value.

Private Sub Company_KeyUp(KeyCode As Integer, Shift As Integer)
Me.Datagrid.Form.Requery
MsgBox (Me.Company.Value)
End Sub
Similar Threads
KeyUp event for an MDI child form.

using C# VS2003 private void textBox2_KeyUp(object sender, System.Windows.Forms.KeyEventArgs e) { if(e.KeyCode== Keys.Enter) { MessageBox.Show("yay"); } }

Form KeyUp event

hi all, In my windows form, form_keyup event is firing if there is no controls in form. If i place any control like textbox,then its not getting fired. How can i fire keyup...

MessageBox with KeyUp and Form with KeyPreview

Hi Guys, Here is my problem, but maybe someone can help me with this. Background: 1. Using C#. 2. I'm having a form which the KeyPreview is on (and must stay like this)...

KeyUp in response to MessageBox ends up in main form

I am dispalying a message box from my main form with the following code: DialogResult response = MessageBox.Show( "Delete Location ?", "Delete", MessageBoxButtons.YesNo, ...

MDI Form and KeyUp Event

Is it possible to capture keypress events (KeyDown, KeyPress, KeyUp) for an MDI form? I have created a simple form where I only changed its name and its IsMdiContainer...


All times are GMT. The time now is 01:33 AM. | Privacy Policy