Add more than one record to a form

[Former Community Member]

Hello all. I am trying to add records to a form from an MS Access query. When I add the field from the DataConnection I only get input from the first record. I have tried linking to the table the query writes to directly as well as using the SQL statement in the dataconnection. I am very new to connecting to a database and to Designer in general. Any help would be greatly appreciated.

[Former Community Member]

Hi,

I'm having the same problem. I create the data connection to the access database, create a subform, check off "repeat subform for each data item" and i still get only the first record. somehow this is not iterating through the recordset.



UUUUGGGGGHHHHHH!!!!!!