Input from Form - is what I want possible

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

Good Day All,


Here is my situation.

I have a form with a drop-down box. The drop down box's control
source is a query that displays all of the date's that a client
participated in a event. Currently I cannot input new information
into this drop-down. Is it possible to input data via that drop-down
or can I not because it is based on a query not a table.


Thanks for any assistance
- Rich
 
Probably, you can't add data to the combo box (dropdown) because the
LimitToList property is set to "Yes". However, it may not be a good idea to
set it to "No". A lot of bad data can get entered that way. On my website
(www.rogersaccesslibrary.com), is a small Access database sample called
"LimitToList.mdb" which illustrates several ways to handle this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Probably, you can't add data to the combo box (dropdown) because the
LimitToList property is set to "Yes". However, it may not be a good idea to
set it to "No". A lot of bad data can get entered that way. On my website
(www.rogersaccesslibrary.com), is a small Access database sample called
"LimitToList.mdb" which illustrates several ways to handle this.

--
--Roger Carlson
MS Access MVP
Access Database Samples:www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
Click to expand...

Thanks for the response Roger,

I checked and the Limit To List option is set to No.

- Rich
 
Okay, let's back up. You said in your original question that your "control
source" is a query. Did you mean your "row source" was a query? If so,
what is the control source (in other words, what field is the combo box
bound to?)

Second question: Are you trying to add data to the dropdown list? Or trying
to add values not in the list to the bound control?

Lastly, I also have a sample called "LimitToListAlternative.mdb" which
allows you to add values to your row source without relying on the
LimitToList property. You might look at that for ideas.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Thanks for the reply Roger,

sorry it took so long to reply, I've been on vacation.

I did indeed mispeak... my rowsource is a query.

The control source is blank because this drop-down is accessing a
table that is independent of the table that the form is based on.

I would like to be able to have my users type something into the drop-
down and that data go into the table. I don't think this is possible
but I had to ask. Perhaps a sub-form would be better suited to this
task?
 
Back
Top