Blank Form

[Prince]

Goodnight Everybody
I made a form to display and search some data from table. I added two fields where user can Inter keywords for search (ex. Account# or Username) to move to data record.
Everytime I open taht form It diplays the first record in the table.

Is it possible to diplay balnk fileds as default when I Open that form and data appear only when a user searchs for specific field and finds a match, then he will be able to see data from that table and novgate?

 

[Jack Cowley]

Base your form on a table or a query and show the fields that you want the user to see. When the form is finished create a combo box using the Wizard and on the Wizard's first screen select the 3rd item, "Find a record...". Finish the Wizard and then the user can select the UserName from the combo box and the proper record will be displayed. You can do a combo for AccountNumber as well....

hth,
Jack