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 ?
You need to be a bit more precise with your descriptions. Is the problem that you only get the first field filled or only the first record of a multi-record table shows up? I quickly tested a sample and it filled all fields if the data binding is done properly between dataconnection and fields.
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.
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.