|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#11
January 1st, 2010, 08:39 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Combo boxes...
On Fri, 01 Jan 2010 19:55:57 GMT, "thewabit via AccessMonster.com"
u57141@uwe wrote: I just want to make sure.. the [YourFormName] should be substituted with my form name like so [frmobservation]...correct? Exactly - you hadn't posted the formname so I used a substitute. Does it work? Did you try it? -- John W. Vinson [MVP] 
|
|
#12
January 1st, 2010, 10:52 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo boxes...
I am just now starting on it again...will post results soon...thanks!
John W. Vinson wrote: I just want to make sure.. the [YourFormName] should be substituted with my form name like so [frmobservation]...correct? Exactly - you hadn't posted the formname so I used a substitute. Does it work? Did you try it? -- Message posted via http://www.accessmonster.com
|
|
#13
January 1st, 2010, 11:11 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo boxes...
It didn't seem to work.
It doesn't matter what I select in CmntAreaCode, there are no selections listed in obcomments. John W. Vinson wrote: I just want to make sure.. the [YourFormName] should be substituted with my form name like so [frmobservation]...correct? Exactly - you hadn't posted the formname so I used a substitute. Does it work? Did you try it? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1
|
|
#14
January 1st, 2010, 11:28 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo boxes...
How do I know if it is a long integer or auto numbering?
thewabit wrote: I am just now starting on it again...will post results soon...thanks! I just want to make sure.. [quoted text clipped - 4 lines] Does it work? Did you try it? -- Message posted via http://www.accessmonster.com
|
|
#15
January 1st, 2010, 11:31 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo boxes...
On Fri, 01 Jan 2010 23:11:02 GMT, "thewabit via AccessMonster.com"
u57141@uwe wrote: It didn't seem to work. It doesn't matter what I select in CmntAreaCode, there are no selections listed in obcomments. Please post the following: current SQL of the two RowSources ControlSource, ColumnCount, ColumnWidths, and Bound Column of both combos It may be that the obcomments combo box simply isn't showing the desired value. Question: is Comment a Memo field? If so it won't work in a combo box. -- John W. Vinson [MVP]
|
|
#16
January 2nd, 2010, 12:17 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo boxes...
On Fri, 01 Jan 2010 23:28:52 GMT, "thewabit via AccessMonster.com"
u57141@uwe wrote: How do I know if it is a long integer or auto numbering? Open the table in design view. Look at the datatype of the field. It might be Number (with Long Integer in the field properties on the lower left), or it might be Autonumber, or it might be something else. -- John W. Vinson [MVP]
|
|
#17
January 2nd, 2010, 12:29 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo boxes...
Here are the 2 querys in the rowsource for "CmntAreaCode" and "obcomment"
respectively: SELECT tblCmntAreas.CmntAreaCode, tblCmntAreas.CmntAreaName FROM tblCmntAreas; SELECT Comments, CmntAreaCode, CommentID FROM tblComments WHERE CmntAreaCode=Forms!frmobservations!CmntAreaCode ORDER BY tblComments. CmntAreaCode; When I typed in the SQL you suggested on obcomment and saved it, the brackets fell away...is that normal? CmntAreaCode Box: ControlSource = CmntAreaCode ColumnCount = 2 Column Width = 0.5";2" Bound Column = 1 ObComment Box: ControlSource = ObComment ColumnCount = 3 Column Width = 10";0";0" Bound Column = 1 Finally, if you mean the comments field in the table "tblcomments"...it is a text field. Also, I currently do not have any requery language in the afterupdate. John W. Vinson wrote: It didn't seem to work. It doesn't matter what I select in CmntAreaCode, there are no selections listed in obcomments. Please post the following: current SQL of the two RowSources ControlSource, ColumnCount, ColumnWidths, and Bound Column of both combos It may be that the obcomments combo box simply isn't showing the desired value. Question: is Comment a Memo field? If so it won't work in a combo box. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1
|
|
#18
January 2nd, 2010, 12:41 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo boxes...
Both table are Long Integers
John W. Vinson wrote: How do I know if it is a long integer or auto numbering? Open the table in design view. Look at the datatype of the field. It might be Number (with Long Integer in the field properties on the lower left), or it might be Autonumber, or it might be something else. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1
|
|
#19
January 2nd, 2010, 03:18 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo boxes...
On Sat, 02 Jan 2010 00:29:35 GMT, "thewabit via AccessMonster.com"
u57141@uwe wrote: Also, I currently do not have any requery language in the afterupdate. That's why it's not working. The second combo box has no way to know what you've selected in the first one. -- John W. Vinson [MVP]
|
|
#20
January 2nd, 2010, 04:34 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo boxes...
I will add it back and see what happens. Does all the other stuff look normal?
John W. Vinson wrote: Also, I currently do not have any requery language in the afterupdate. That's why it's not working. The second combo box has no way to know what you've selected in the first one. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
