searching..

Tech

Registered User.
Local time
Today, 18:37
Joined
Oct 31, 2002
Messages
267
I forgot how, tried to look over the previous forms but can't figure it out.


I made a query and in a switchboard, I want to load a specific form, this form is a form which the user enters a particular piece of text in a txtbox and hits a button, and this button goes and does this search on a particular query.

in the query, I told the field I want it to apply this filter to:

Code:
[forms]![frmveot]![txtEmpID]


but what is the button called which enables u to do this search? it was in one of the command button wizards..i can't remember now... help!
 
Adding the following to the On Click event of the Command buton with run the Query...

DoCmd.OpenQuery "NameofQuery",acViewPreview

HTH
 
thanks....but it shows up as a print preview :( how can i show it up in a form type view? Cause this form is also going to have extra unmade fields, which calculates commission etc...
 
change the acView to the appropraite on you want, acViewNormal, acViewEdit, etc...

HTH
 

Users who are viewing this thread

Back
Top Bottom