Get Value RRS feed

  • Question

  • I want to get data of a person info from another form or data.

    For example My Customer Name Is red in customer form, but she has a name existing in another data or another form, but I want only the exact data from a specific field.

    Is that possible? thanks for the reply. and can you send me the simplest code possible I'm a newbie, by the way I'm using Access 2016. thanks

    Monday, March 28, 2016 2:23 AM


All replies

  • Hi. Data in Access are stored in tables and merely displayed in forms. So, if the data you're looking for are stored in your tables, then yes, you can retrieve them for your form. You may not even need code to do it.

    Monday, March 28, 2016 3:11 AM
  • thank you for your response, for example my customer name is red in table_customer, how do I get the value of a field under his name in table_details, thank you
    Monday, March 28, 2016 3:16 AM
  • You can either use the DLookup() function or use a query joining the two tables together. Hope that helps...
    Monday, March 28, 2016 12:20 PM