Results 1 to 4 of 4
  1. #1
    JEPEDEWE is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    3

    empty textfield

    Hi,
    I have a form "fiche"
    On this form a field containing the name
    On this form I made a pushbutton to open another form. (let's call it form2)
    Form2 has a textfield with following property: ="Dossier van: " & [Formulieren]![fiche]![name]
    When I open the form2 (from "fiche" that remains open) nothing is displayed, but when I move to the textfield and click, the correct name is displayed.
    What can I do about this?

    Thanks

    JP

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,128
    Requery the form
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  3. #3
    PRyan's Avatar
    PRyan is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Oct 2017
    Posts
    6
    Is the name on the first form entered by the user and then the second form opened?
    In that case you`d need to close the first form, re-open the first form and then the second form.
    If the name is coming from a table field why not use that field to populate form2`s data.

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,845
    be aware that name is a reserved word and should not be used for field, control or form/report names.

    me.name will return the name of the form for example

    so try changing the name of your field and control to say ficheName and txtficheName respectively

Please reply to this thread with any new information or opinions.

Similar Threads

  1. DLookup with textfield in criteria
    By smeghead67 in forum Programming
    Replies: 4
    Last Post: 08-07-2012, 12:18 PM
  2. Replies: 2
    Last Post: 04-23-2012, 10:13 PM
  3. DLOOKUP where TEXTFIELD > SEARCHSTRING
    By Whizbang in forum Access
    Replies: 1
    Last Post: 12-20-2011, 01:48 PM
  4. Replies: 4
    Last Post: 11-20-2011, 01:08 PM
  5. Replies: 0
    Last Post: 09-21-2008, 11:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums