|
|
How do i get a combo box to enter data in a table from a form?
I want to use a form for data entry. Within that form I have two combo boxes
to look up recurring data. When I select an item and expect it to write to
another table it does not. What must i do to accomplish this?
|
|
0
|
|
|
|
Reply
|
 Utf
|
10/10/2007 2:56:00 PM |
|
You'll need to tell us more details about your form's setup and the tables'
designs. Your question suggests, though, that you may be storing data
redundantly in your database, which usually is unnecessary and may be a
source of future data integrity problems.
--
Ken Snell
<MS ACCESS MVP>
"Joe Owens" <Joe Owens@discussions.microsoft.com> wrote in message
news:4542310C-B696-4A94-84F2-A7AF97E36C7C@microsoft.com...
>I want to use a form for data entry. Within that form I have two combo
>boxes
> to look up recurring data. When I select an item and expect it to write to
> another table it does not. What must i do to accomplish this?
|
|
|
0
|
|
|
|
Reply
|
Ken
|
10/10/2007 3:06:09 PM
|
|
What is the form's RecordSource query? Are you actually trying to update the
data in these two tables via your form, or do you want to use those two
tables as "lookup" values that you then enter into whatever table is being
updated by the form?
--
Ken Snell
<MS ACCESS MVP>
"Joe Owens" <JoeOwens@discussions.microsoft.com> wrote in message
news:53ED0572-BF07-4ADF-858E-1ED67B51B0D1@microsoft.com...
>I have two tables that I am using as a source to my form. One has dates
> (10/10/2007) the other has a series of names (Joe Owens). The form I am
> using
> will be upated weekly, but only specific values which are check boxes. I
> want
> to be able to use the combo boxes to reduce typing.
>
> "Joe Owens" wrote:
>
>> I want to use a form for data entry. Within that form I have two combo
>> boxes
>> to look up recurring data. When I select an item and expect it to write
>> to
>> another table it does not. What must i do to accomplish this?
|
|
|
0
|
|
|
|
Reply
|
Ken
|
10/10/2007 3:52:21 PM
|
|
|
2 Replies
245 Views
(page loaded in 0.084 seconds)
Similiar Articles: Prevent combo box from updating a table - microsoft.public.access ...... values from a query, when >I close the form it inserts the value which is in the combo box into the >table from which that data came from. How do I prevent the insert? How do I control a text box via another combo box - microsoft ...I have a form with a combo box ... of Key in Table - microsoft.public ..... validate data in a combo box ... Text Box From Combo in Access 2007 | eHow.com... user can enter ... Can I validate data in a combo box vs another table? - microsoft ...You can have a combo box ... how do I add data from one table to another ... users can enter in a table field or a control (such as a text box) on a form. combo box on form to update different table - microsoft.public ...... In the main form ... the One form on the patients table. You can have a combo box ... up a form using data ... which is a FK from the "NoteType" table, so when you enter ... Assigning Variable from Combo Box - microsoft.public.access.forms ...... in a form (named: Artist2) and I've populated this combo box from a table ... INSERT INTO ... Values To Combo Box List Assigning Variable ... Filter Form to get a data ... Filter Datasheet based on Combo Box selection - microsoft.public ...... method is invalid because the form or report isn't bound to a table ... Filter Datasheet based on Combo Box selection - microsoft.public ... Filter Form to get a data ... Adding Data to a lookup column in a form - microsoft.public.access ...... data from. How do I get it to be add to the lookup table in addition to the main table that the form ... table. > strTmp = "INSERT ... combo box on the Products form ... microsoft.public.access.formsLimit Combo Box Utf 0 337 I will do my best to make some since. I have a form for entering data into a table named dispatchdetatils The ... check register in which I enter ... how do I enter a list in a list box or a combo box - microsoft ...... or a combo box but i can not find out how to do ... to a table field or form control when you want to enter ... the form or data access page, make sure that the list box , combo ... Access combo box control by another data field - microsoft.public ...Hi, I use a combo box in a form with look-up from a table for selecting data. ... data in a combo box vs another table ... data in a field - Access ..... users can enter ... How to Enter Data From a Combo Box in Access | eHow.comHow to Enter Data From a Combo Box in Access ... to the place in the form where you wish the combo box ... this software is the combo box,... How to Enter Data Into a Table ... How to Use an Access Combo Box to Add Data to Fields | eHow.com... Combo Box to Add Data to ... to enter information into the underlying table. A drop-down list is a control used in an Access form.... How to Create an Access 2007 Combo Box ComboBox Databinding SampleThe main form contains the combo box controls, button controls to load data, and two label controls and ... product entry Chai from the products table bound to the combo box ... How To Make a Lookup Combo Box in a Grid - Microsoft Support... may want to limit the user's choices for data entry by using a lookup table in a combo box. ... In the Destroy event of the form, enter the following line ... Create a list box, combo box, or drop-down list box - Access ...... box, combo box, or drop-down list box that looks up values in a table or query, make sure the form or data ... in a combo box on a form. In the ListRows property box, enter a ... 7/17/2012 6:57:29 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
38 followers. 