Form/on Open

[rhonda11]

I have a form and there's a combox for lookup which can be pull each record up and the record's information would appear on the form. However, when the form is opened, the first record always appeared. How can I get a blank form when it's open and they can start to find the existing records only (this form is not for adding new record, only for retreive purpose). I also wanted the user to restrictly use the combox for lookup or find a particular record. I have some user use the "CTRL + F" for find. I do not want that. Can it be disable?

Thanks in advance.

 

[MazeWorX]

set your controls default value to "" Remember amateurs built the ark - professionals built the Titanic

 

[rhonda11]

Thanks for your reply, but can you be more specific as to where the control default value is in the form, the text...etc? Will this also disable the find command (CTRL + F)?

Thanks again

 

[MazeWorX]

right click the control,select properties and set the "default Value" to ""

Not sure on the Ctrl+F Remember amateurs built the ark - professionals built the Titanic

 

[rhonda11]

MazeWorx,

Again, which control are you suggesting? If I go to the form property, there are no "Default Value". I only see the "Default Value" from the text box control. If it is the text box control, which one? I have repost the question, I hope it make a lot more sense.

Thanks,


Rhonda

 

[MazeWorX]

controls are textboxes,comboboxes,listboxes,command buttons etc.


The control that displays the data. Any control that displays data that you wish "not" to, then change the default value in each one Remember amateurs built the ark - professionals built the Titanic

 

[rhonda11]

Ok, I tried that and it didn't work. The form is still populated the very first record. Any other suggestion?

Thanks, MazeWorx