Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    361

    Unanswered: populate unbound text box

    Is it possible to populate an unbound text box from a bound text box that is associated with a query?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912

    Re: populate unbound text box

    Originally posted by tjarvas
    Is it possible to populate an unbound text box from a bound text box that is associated with a query?
    Hi

    I haven't checked, but if I've understood you right I think the unbound text boxes default value could be set to =forms!FormName!BoundTextBox

    Alternatively, you could set it up in VBA if you need more control (e.g. the record source is requeried). Pop the code in to the event that requeries the form (e.g. if a button is pressed).

    dim strBound as string 'or an appropriate data type

    strBound = forms!FormName!BoundTextBox

    forms!FormName!UnBoundTextBox = strBound

Posting Permissions

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