search form help (97)

Topic

New Reply

I created a form with an unbound text field, txtRefNum. This form is bound to a query whose criteria for RefNum is txtRefNum. I didn

Reply | Quote

Replies

This is smart way to handle your forms. All you need to do to make it work, however, is to fully qualify the control location. That is:

Forms!youformname!txtRefNum

Reply | Quote

You also need to requery the form in order to populate it with the current query results.

Reply | Quote

Good catch. I completely missed the statement that there was no code in AfterUpdate.

Reply | Quote

And as Charlotte caught (and I had missed), you need to put a Me.Requery in your AfterUpdate event for txtRefnum.

Reply | Quote