Writing in Drop-down-list in DAP 2

[Techniproshop]

Hi all. I noticed that a drop-down-list created in DAP doesn't work like in Access Forms. Normally, I would be able to delete the information if I want the field blank. Now what's happening is I select the data and save it into the field but I'm not able to delete that information after it's beeing saved.

My other question is also related to this subj. In Access Forms, when you type in a combobox, you get the first record that match what your are typing. Are you following? Very hard for me to explain that in english
Anyhow, when I select the combobox, I cannot type in. All I can do is use the vertical selector and choose one line.
Is there a way to unlock this so I can type in or it's just not possible in DAP? If not, what's the better option to delete data in a field that use a drop-down-list?

Thanks alot.

 

[fneily]

Do not confuse the Access drop down with HTML drop downs. The DAP drop down is called a Dynamic Html drop-down and needs to be coded using JScript or C or any of the Internet languages to function differently from what you want. So you may want to explore DHTML.
I don't understand the first paragraph of your post. You selected from a combobox and it saved a field and you want to delete that field????? Confusing. Restate more clearly what you want.

 

[Techniproshop]

Ok, I selected data with the DHTML drop-down but I cannot delete this info after I selected it. Example: I have a DHTML drop-down bounded to the field VILLAGE in the tblProjects. Only the primary key is saved in the field VILLAGE. If I want to delete that information later, I cannot because the DHTML drop-down doesn't let me delete the info. I have to go directly in the table to delete that info. In a normal text control, I can click in the box and delete the info, why not with the DHTML?

Is it better?

 

[fneily]

why not with the DHTML?". Because.
You will first create a regular query that just picks off VILLAGE from tblProjects. You will use this query as the source for your combobox.
Then you will also place the actual VILLAGE field from tblProjects on the DAP.
So you'll see two VILLAGES. However, one will say "Select a Village", the other will display the info. You'll then be able to delete the record. IT WILL NOT DELETE THE COMBOBOX ITEM UNTIL THE NEXT SESSION DUE TO BINDING.

Concept. When you create a DAP, the controls are BINDED to the field, like supersuperglue. You must remember the web page is being used by someone in Iowa and the page must go through thousands of miles of telephone lines to attach to the field in the Access table. It's not like working on a self contained computer.

 

[Techniproshop]

I was thinking of doing it that way then I thought I could avoid having 2 village control on the page. Thanks for the info.

 

[Techniproshop]

Well I forgot that "the actual VILLAGE field from tblProjects" is numeric so I get a number displayed in the textbox instead of the village name...!

 

[Techniproshop]

I finally decided to add the line "unknown" in each field so if the user doesn't know the info, by default it will be unknown and this can also be filtered after all. So the user no longer need to delete the info in those fields.
Thanks.