Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Location
    Belfast, UK
    Posts
    87

    Unanswered: insert data from form to table/s

    Hi I've a database with a form that users enter data in, there are various comboboxes that contain the text element from other tables.

    everything about the case is store in two main tables.

    tblcase and tblreview these have numbered references to the data in the tables that the comboboxes relate to.

    How on earth do I tell the database that the numbered value in the relevant field of tblcase/tblreview is equal to the text string in the combobox. At the minute it keeps say #name? or saying the value entered is not allowed.

    Thanks!

  2. #2
    Join Date
    Dec 2003
    Posts
    36
    as far as i can make up you are trying to compare / write an number with/in a text field.

    you have to take 2x number or 2x text

    greetz
    ... man man man ...

  3. #3
    Join Date
    Dec 2003
    Location
    Belfast, UK
    Posts
    87
    not quite.

    example:

    form
    textbox1(value from table4,field1[primary key])
    combobox1(value from table1, field2)
    combobox2(value from table2, field2)
    combobox3(value from table3, field2)

    table4
    field1
    field2(value from table1, field1)
    field3(value from table2, field1)
    field4(value from table3, field1)

    when a command button is clicked on the form it should save the record in table4.

  4. #4
    Join Date
    Dec 2003
    Posts
    36
    Originally posted by bertthefreak
    not quite.

    example:

    form
    textbox1(value from table4,field1[primary key])
    combobox1(value from table1, field2)
    combobox2(value from table2, field2)
    combobox3(value from table3, field2)

    table4
    field1
    field2(value from table1, field1)
    field3(value from table2, field1)
    field4(value from table3, field1)

    when a command button is clicked on the form it should save the record in table4.
    i don't know i completely understand the problem, but ill give it a try
    You can write a code after the button to write the record , something like: on click: table4.field1 = me.txtbox1

    or link in access itself to table for (eventually make some extra txt's with the control source of table4)
    ... man man man ...

Posting Permissions

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