Professional Web Applications Themes

Linking a text box in a form problem - Microsoft Access

Hi I have a form which has a record source as table1.with various textboxes linked to fields within table 1 Within this form i have one textbox which i want to display text that has been entered into a text box in table 2 Is this possible, and if so how would i do it Thanks Paul...

  1. #1

    Default Linking a text box in a form problem

    Hi
    I have a form which has a record source as table1.with various textboxes
    linked to fields within table 1
    Within this form i have one textbox which i want to display text that has
    been entered into a text box in table 2
    Is this possible, and if so how would i do it

    Thanks

    Paul


    Paul Watkins Guest

  2. #2

    Default Re: Linking a text box in a form problem

    On Thu, 10 Jul 2003 19:04:47 +0100, "Paul Watkins"
    <paul.watkins4ntlworld.com> wrote:
    >Hi
    >I have a form which has a record source as table1.with various textboxes
    >linked to fields within table 1
    >Within this form i have one textbox which i want to display text that has
    >been entered into a text box in table 2
    Which record in Table 2? There might be a million records. How are
    Table1 and Table2 related?
    >Is this possible, and if so how would i do it
    A Combo Box might work; you might be able to use DLookUp; or you could
    base the Form on a query joining Table1 and Table2. Without knowing
    more about your table structure it's impossible to say which would be
    best.

    John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
    [url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]
    John Vinson Guest

Similar Threads

  1. linking form text fields
    By David_O_Rourke@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 1
    Last Post: October 7th, 01:52 AM
  2. Linking form to MySQL database.
    By dreamx.0 in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: August 28th, 04:45 AM
  3. Linking two form fields for text flow?
    By Dave_Cedrone@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 0
    Last Post: August 11th, 06:53 PM
  4. linking text problem.
    By tru178 in forum Macromedia Flash
    Replies: 3
    Last Post: October 21st, 03:58 AM
  5. Linking of several tables in a heirarchical form
    By Jacob in forum ASP Database
    Replies: 10
    Last Post: July 2nd, 09:39 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139