I created ODBC connection for Acces Database (.accdb)
I have a form with multiple fields, ex : Product Name, Product No.,Category , etc , and i dont know why my form show only first record "Product Name".
Can you help me ?
Now i have a connection to the Access DB(.mbd) and everything works good. All what i did is to click "Build" and replace the DSN from ODBC Data Source Administrator with other Access DB (.accdb) with same tabels and same query. But in PDF forms i get only first column from first Table from DataBase.
Since I receive information from the database it means that the connection was made correctly, what I don't understand is why it doesn't bring all the records from DB.
Your form should look somewhat like this here:
Your Data View should show zhe ODBC connection with all the table fields available and they should all be bound (logo on the right). I am guessing that only your Product Name is bound? You can also see this in the Data Binding under the Binding tab on the right. Make sure they are all correctly bound.