Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    12

    Unanswered: set data in a table

    Hi
    I have a form to enter data in a table2
    I have a ComboBox like
    select [table1].[a],[table1].[b] from [table1]
    bound column 1
    and I enter data only from column [table1].[a] to a field [c] in a [table2]

    How to enter data - [table1].[b] in a table in other field - [table2].[d]

    thanks

  2. #2
    Join Date
    Oct 2003
    Location
    São Paulo - Brazil
    Posts
    91

    Re: set data in a table

    Originally posted by stanimir_p
    Hi
    I have a form to enter data in a table2
    I have a ComboBox like
    select [table1].[a],[table1].[b] from [table1]
    bound column 1
    and I enter data only from column [table1].[a] to a field [c] in a [table2]

    How to enter data - [table1].[b] in a table in other field - [table2].[d]

    thanks
    if your ComboBox name is CboBox, just do:

    me.YourFiledName = CboBox.Column(1)

    Remember: CboBox.Column(0) has the [table1].[a] value´s.
    My environment: Windows XP/ Access 2000 - Using Microsoft DAO 3.6 Library

  3. #3
    Join Date
    Nov 2003
    Posts
    12
    is that mean when I select [table1].[a] value ,the value in tha same row [table1].[b] i can store in [table2].[d]
    have I to create hiden Textbox whit control source [table2].[d]
    and in AfterUpdate procedure on seting [table1].[a] values to write
    me.myHiddenTextBox=CboBox.Column(1)
    is that enough
    and how to create or convert to CboBox
    thanks

  4. #4
    Join Date
    Oct 2003
    Location
    São Paulo - Brazil
    Posts
    91
    Originally posted by stanimir_p
    is that mean when I select [table1].[a] value ,the value in tha same row [table1].[b] i can store in [table2].[d]
    have I to create hiden Textbox whit control source [table2].[d]
    and in AfterUpdate procedure on seting [table1].[a] values to write
    me.myHiddenTextBox=CboBox.Column(1)
    is that enough
    and how to create or convert to CboBox
    thanks
    No. After u have created a ComboBox, you may access all of its columns in that way without doing anything more.

    I mean, create (with wizard help, for instance) and have access to all its columns!
    My environment: Windows XP/ Access 2000 - Using Microsoft DAO 3.6 Library

  5. #5
    Join Date
    Nov 2003
    Posts
    12
    ok
    Thanks
    it works very good

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •