PC Review


Reply
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
 
 
 
 
Banned
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
 
 
 
Reply

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


Features
 

Advertising
 

Newsgroups
 


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