PC Review

Thread Tools Rate Thread

Combo box values and continuous forms

New Member
Join Date: Jul 2011
Posts: 1
      6th Jul 2011
Hello, I am rather new to Access programming, and have a problem that I haven't been able to solve despite hours of looking on-line.

My basic problem is that I have a continuous form with one text box adjacent to one combo box. The text box values come from one table, the combo box values from a related table. On the form the combo boxes allow the user to rate what is in the text box (rating of 1-5). After these 20 items have been rated, I want to submit those values (both the text box and combo box) as unique records in a third table, whose fields are related to the original two tables. I can't seem to find a way for Access to treat each combo box value on the form as a unique value. Any advice would be greatly appreciated. Thanks
Reply With Quote
Join Date: Jul 2011
Posts: 16
      21st Jul 2011
Create a new field on the same table from where the textbox value is taken; for recording the rating value selected from the combobox control,

Set the Control Source property of the Combo Box to the new field to record the combobox selection.

When the user selects the rating number it will be recorded on the same table of the Textbox.
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Continuous Forms - Combo box.RowSource Stapes Microsoft Access 2 23rd May 2007 02:28 PM
combo box filter continuous form with cmd button but no null values showing heidii@zirklefruit.com Microsoft Access Forms 5 8th Feb 2007 04:23 AM
Combo box color change on continuous forms Kevin Bruce Microsoft Access Forms 2 2nd Mar 2004 06:45 PM
Combo box depending on combo box in continuous subform XMan Microsoft Access Form Coding 1 21st Oct 2003 08:23 AM
Text of combo box disappears when using continuous forms Russell Microsoft Access Forms 1 20th Oct 2003 04:34 PM




All times are GMT +1. The time now is 08:43 PM.