I wish to be able to pull data at the current cursor location in my word document from a specific field (ThirdField) from a particular table (Messages) in my access database (MyDatabase) in response to the click event of a button (Button1) on my Visual Basic For Applications (VBA) Form.
This table (Messages) has four fields: note_id, date, client_id, ThirdField.
I would like to pull Data from the ThirdField from All the Records in the Table where client_id is 222 in a chronological order (ascending or descending based on the date they were saved).
That is I would like to pull data from ALL the records from ThirdField for Client 222 from the “Messages” table in a chronological order.
The name and path of my source database are as follows:
Source=G:\ My Folder\MyDatabase.mdb
This is question is related in theme to a previous question I asked on this Forum.
My original question on this theme and its solution are posted here:
Many thanks for your help.