A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

text box on Access subform will not allow data entry? Fix?



 
 
Thread Tools Display Modes
  #1  
Old August 27th, 2006, 06:27 PM posted to microsoft.public.access.forms
amarillort
external usenet poster
 
Posts: 3
Default text box on Access subform will not allow data entry? Fix?

I have a subform located under a tab on a form. It will not allow me to
enter any data into the textbox. It is a combo box linked to a table. I
have set bound columns, column widths, and column count correctly. What am I
overlooking?
  #2  
Old August 27th, 2006, 08:36 PM posted to microsoft.public.access.forms
ruralguy via AccessMonster.com
external usenet poster
 
Posts: 1,172
Default text box on Access subform will not allow data entry? Fix?

I suspect the query the SubForm is based on is not updateable. Does your
data entry attempts just beep?

amarillort wrote:
I have a subform located under a tab on a form. It will not allow me to
enter any data into the textbox. It is a combo box linked to a table. I
have set bound columns, column widths, and column count correctly. What am I
overlooking?


--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200608/1

  #3  
Old August 27th, 2006, 08:55 PM posted to microsoft.public.access.forms
J. Goddard
external usenet poster
 
Posts: 159
Default text box on Access subform will not allow data entry? Fix?

Hi -

What, if any, error messages do you get? Is the "limit to list"
property of the combo box set to "Yes" (it should be "no")

John


amarillort wrote:

I have a subform located under a tab on a form. It will not allow me to
enter any data into the textbox. It is a combo box linked to a table. I
have set bound columns, column widths, and column count correctly. What am I
overlooking?


  #4  
Old August 27th, 2006, 09:14 PM posted to microsoft.public.access.forms
amarillort
external usenet poster
 
Posts: 3
Default text box on Access subform will not allow data entry? Fix?

I do not get any error message. The "limit to List" is set to 'No" also. I
do not get any beeps either. The forms control source is a table.

"J. Goddard" wrote:

Hi -

What, if any, error messages do you get? Is the "limit to list"
property of the combo box set to "Yes" (it should be "no")

John


amarillort wrote:

I have a subform located under a tab on a form. It will not allow me to
enter any data into the textbox. It is a combo box linked to a table. I
have set bound columns, column widths, and column count correctly. What am I
overlooking?



  #5  
Old August 27th, 2006, 09:44 PM posted to microsoft.public.access.forms
J. Goddard
external usenet poster
 
Posts: 159
Default text box on Access subform will not allow data entry? Fix?


Are you trying to enter new records into the same table the combo box is
based on? Remember that although a combo box can display several fields
from a table or query, it can only add to or update one field - the one
it is bound to.

Are the property settings on the subform correct, to allow you to add
new records, or to edit existing data?

John


amarillort wrote:

I do not get any error message. The "limit to List" is set to 'No" also. I
do not get any beeps either. The forms control source is a table.

"J. Goddard" wrote:


Hi -

What, if any, error messages do you get? Is the "limit to list"
property of the combo box set to "Yes" (it should be "no")

John


amarillort wrote:


I have a subform located under a tab on a form. It will not allow me to
enter any data into the textbox. It is a combo box linked to a table. I
have set bound columns, column widths, and column count correctly. What am I
overlooking?




  #6  
Old August 27th, 2006, 10:09 PM posted to microsoft.public.access.forms
ruralguy via AccessMonster.com
external usenet poster
 
Posts: 1,172
Default text box on Access subform will not allow data entry? Fix?

Can you change any other control on that SubForm?

amarillort wrote:
I do not get any error message. The "limit to List" is set to 'No" also. I
do not get any beeps either. The forms control source is a table.

Hi -

[quoted text clipped - 7 lines]
have set bound columns, column widths, and column count correctly. What am I
overlooking?


--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200608/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:22 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.