Get Value

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

Answer 1

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.

Answer 2

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

Answer 3

You can either use the DLookup() function or use a query joining the two tables together. Hope that helps...